عــااجــل ,, ارجوا المساعدة

:huh:

A company stores some of its important information in the following files. Create a database to store this information by performing tasks 1-10.

Perform the following tasks…..

1) Convert the files to tables. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.

2) Do the tables exhibit referential integrity? Answer yes or no and then explain your answer

3) Use Chen Notation or Crow’s Foot Notation to show the relationships.

4) Create the conceptual schema (ERD) for the database.

5) Identify the primary keys for these tables

6) Identify the foreign keys for these tables.

Use Microsoft Access program to

7) Design the tables.

8) Create 4 forms to enter additional information in these tables using appropriate tools.

9) Create 4 suitable queries to retrieve useful information from the database.

10) Generate 4 useful reports from the database.