Assignment #2
(80 points)
- Read Chapter #2 "The Relational Model".
- Answer 25 Review Questions at the end of the chapter.
Your answers must include the page number(s) of where the topic is
introduced in the textbook. To provide you an example, I have
answered the first question in the link above.
- Create a database as described in pages 118-135 of the class textbook
AND as shown the video
Creating Relationships
(CC). Your database
must contain three tables "CUSTOMER", "CONTACT", and "PHONE-NUMBER"
that have been created and populated with data. Finally, your
database must contain a 1:N relationship between the CUSTOMER
and the CONTACT tables AND a 1:N relationship between the CUSTOMER
and the PHONE-NUMBER tables. Enter your first and last name as one of the customers.
Save your database as "assignment2.aacdb".
(Data)
- Upload both files to YOUR-CLASS-WEBSITE.
Help
|