Shrewsbury College of Arts and Technology

-

Documents
3 pages
Obtenez un accès à la bibliothèque pour le consulter en ligne
En savoir plus

Description

  • cours - matière potentielle : administrators
  • cours - matière potentielle : file
  • cours - matière potentielle : administrator
  • cours - matière potentielle : whether other factors
  • exposé
  • cours - matière potentielle : within two days
  • cours - matière potentielle : pupils
  • expression écrite
  • cours - matière potentielle : with the name
Shrewsbury College of Arts and Technology Policy Title Disciplinary Policy Policy Number POL/0003/180809 version 5 Approved By AMT Author Nick Peck: Head of Student Support Date Issued August 2009. Revised May 2011 Policy Owner Head of Student Support
  • disciplinary procedure
  • technology policy title
  • misconduct
  • ages of 16-18 years on a full time course
  • disciplinary policy
  • student support
  • college
  • student
  • time

Sujets

Informations

Publié par
Nombre de visites sur la page 18
Langue English
Signaler un problème
CS 110 – Introduction to Information TechnologyAssignment 5 – Microsoft Access Part IIDue Date: 5 pm, Friday, November 18 The purpose of this assignment is to continue to help you to develop a deeper understanding of modern database theory and practice. You will once again use Microsoft Access as an accessible tool for this purpose. The same ideas would apply to Oracle, Sybase, MySQL, PostgreSQL, or to any otherrelationaldatabase management system, although the details of usage would of course differ. By the end of this assignment you will be familiar with importing data into relations, multitable joins, and the use of queries to “drill down” specific items in a database. The basic idea in this assignment is to use a somewhat more realistic schema for an order entry system, and to use some more of the important capabilities of Access. In terms of the schema, in this case acustomerhave zero or more willorders. Anorder willhave one or moreorder items. Anorder itemwill designate a singleproduct, and will belong to a singleorder. In other words, we’re introducing the concept of anordera set of as order items.1) Create a blank database called Assignment5. In this database, create tables with the following names and schemas. In each case, designate the first field of each record to be the primary key. CustomersCustomerIDCodeName Address City State Zip OrdersOrderIDCustomerID OrdersItemsOrderItemIDOrderID ProductID Quantity ProductsProductIDName Cost