Database Management System

Part 1 - Database Creation (MS Access)

Task 1: Create a Databases

To create thr PetDB databases, perform tge following steps:
1. Start MS Access
2. Click blank databases option in the New File task pane.
3. In the New Database dialog box type PetDB, then click the Create button.

Task 2: Create the Owner Table

To create the Owner table

1. In the Table button click design view
2. Follow the specification below for the field:

Field name Data type

Owner_id (PK) number
Owner_name text
Owner_Address text

3. save table as Owner

-----------------------------------------------

To create for the Pet table

1. In the Table button click design view
2. Follow the specification below for the field:

Field name Data type

Pet_id (PK) number
Owner_id number
Pet_name text
Pet_breed text

3. save table as Pet

Task 3: Create a relationship

1. In the database window, click the relationship button located on the database toolbar. The relationships window will open.

2. Add the two tables: Owner and Pet tables
3. Drag the Owner_id from Owner Table to Owner_id of the Pet table
4. A diaglog window will appear. Check the Enforces Referential Integrity, Cascade Update Related fields, and Cascade Delete Related Records.
5. Click Ok

ADDITIONAL TASK

Before you will proceed in the Proram Developement. Draw a Entity Relationship Diagram (ERD) of the the system. Refer your diagram to the two tables Owner and Pet