Shrewsbury College of Arts and Technology
3
pages
English
Documents
Obtenez un accès à la bibliothèque pour le consulter en ligne En savoir plus
Découvre YouScribe en t'inscrivant gratuitement
Découvre YouScribe en t'inscrivant gratuitement
3
pages
English
Documents
Obtenez un accès à la bibliothèque pour le consulter en ligne En savoir plus
- 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
- disciplinary procedure
- technology policy title
- misconduct
- ages of 16-18 years on a full time course
- disciplinary policy
- student support
- college
- student
- time
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, multitable 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
