Question

a)    Design the database for your clotting brand company using MS Access. Design tables (as mentioned in part a) with necessary fields (must include primary and foreign keys) and draw the ERD diagram. (Paste the image of ERD diagram using snipping tool in your answer sheet). Use query to fetch any specific information of your interest from more than one table (Paste the complete image using snipping tool in your answer sheet).

Rubrics (Scoring Guide)

- Knowledge = 40%

- Application = 30%

- Synthesis = 30% 

Answer 1

The ER Diagram for the system is provided below, In the picture below Tx is basically the table number, say for example, T1 is table 1, T2 is table 2, and so on...