Exercise $3-$ Relational database

Hide Assignment Information

Instructions

Part A: Designing the Grading Database

Create a schema for your grading database $($a database that stores and

calculates your grades in this course$).$ Remember to use relational model,

primary keys and foreign keys. The database should include at least $3$ tables.

Create this database in MS Access and enter the data you have so far $($your

information, grades received, deliverables weight etc.$).$ Paste screenshots of:

The relationships of the tables.

The data in the tables $($the tables in spreadsheet view$)$

Part B: Textbook Questions

Answer Questions from the Textbook: Refer to your "Database Concepts"

textbook. Answer questions A$,$ B and C from the project James River

Jewelry. PROJECT at the end of chapter $2($project questions, page $147).$ For

each question:

Write the question number $/$ letter.

Copy the question itself in bold.

Provide your answer below the question.