Homework
Databases can contain giga and giga and gigabytes of data.
Databases can be designed to store specific data in one table and other data in abother table. For example, an eCommerce site will store customer data in one table, product data in another table and order data in another table. Even though there are 3 tables, the order table connects the customer to the product - there is a relationship between the data and we have to design a relational database to handle this situation!
Databases can be designed to store specific data in one table and other data in abother table. For example, an eCommerce site will store customer data in one table, product data in another table and order data in another table. Even though there are 3 tables, the order table connects the customer to the product - there is a relationship between the data and we have to design a relational database to handle this situation!
This video will introduce an eCommerce site selling soccer player cards to people who register with their website. It will introduce you to the concept of relational database design.
Task! Download the 2 csv files below and import them into Microsoft Access.
Open an evidence document, eg a Google Doc, and paste screenshots of these tasks:
Open an evidence document, eg a Google Doc, and paste screenshots of these tasks:
- 1. Create a new table called tblOrders and design it to have a unique ID field, a customerID field, a playerID field and an orderDate field.
- 2. Screenshot the Design View of the table and paste it into your evidence document.
- 3. Create relationships between the three tables as shown in the video.
- 4. Screenshot your design into your evidence document.
- 5. Find a way to import the data from orders.csv into the orders table.
- 6. Create a query which shows the customer name and the player name and club for every order made on March 17.
- 7. Save the query as "qryMarch17" and copy a screenshot of your query design into your evidence document.
- 8. Tricky! Create a query grouped by player name that displays the average Aggression Rating for all players sold in March.
- 9. Save the query as "qryAggression" and copy a screenshot of your query design into your evidence document.