exam 2 for cis 110
|
|
![]() Part 1 – Get content for your database and update tables
|
|
Part 2 – Import Data
|
|
Part 3 – Update Table Design Modify table design following best database design practices.
|
|
Part 4 – Add Validation and Lookup Field
|
|
Part 5 – Create Relationships Now that all the tables have had their design optimized and key fields are set the relationships can be set. If you have trouble creating a relationship you may need to modify the table design. Use the following to help create the relationships:
Note: In this design tblOrderDetails is a junction table. A junction table contains 2 FK’s to relate to the PK’s in other tables (tblOrder and tblProduct).
|
|
Part 6 – Create a Filter
|
|
Part 7 – Create Queries The manager wants to set up a discount section by the register with items which cost 99 cents.
|
|
Part 8 – Create a Form
|
|
Part 9 – Create a Report
|
|
Part 10 – Finish and Submit
|
|