WEEK 6

Based on the figure above, create a complete ERD which includes entities, attributes, relationship, relational keys, and cardinalities constrains.

Trace Entities

1. Payment ( Payment_no , Total Payment , Holiday_no )

2. Holiday Maker ( Holiday_no , name )

3. Booking ( Holiday_no , Plot_name , Booking_no , Booking_date , Invoice_No )

4. Invoice ( Invoice , date )

5. Site ( Site_no , Site_name )

6. Plot (Plot_no , Site_no )

Section B

Question 2

Draw A complete ERD

Question 3

A.) What is the meaning of database and databased management system (DBMS)

B.) The are 4 type of attributes. List down and give definition, example and symbol

Answer

A. Database is a collection of related data, design to meet the information needed in an organization and stored it in one specific location. Database Management System (DBMS) is a collection of programs that enables user to create and maintain a database and provide control accsess to database.

B. i. entity attributes (example table) ii. simple attributes (example field name) iii. Multivalue attributes (examples telephone no, mobile no) iv. Derive attributes (example date)

A.) What is the meaning of database and databased management system (DBMS)

B.) The are 4 type of attributes. List down and give definition, example and symbol

Answer

A. Database is a collection of related data, design to meet the information needed in an organization and stored it in one specific location. Database Management System (DBMS) is a collection of programs that enables user to create and maintain a database and provide control accsess to database.

B.

i. entity attributes (example table)

ii. simple attributes (example field name)

iii. Multivalue attributes (examples telephone no, mobile no)

iv. Derive attributes (example date)