Fundamentals of database

Question One

Use your own words to discuss the following:

“Using spreadsheets or typical computer-based filing systems looks a reasonable choice for organizing personal data. However, it is not sufficient to use such systems when the amount of data becomes huge. In such case, it may be time to implement a database.”

Question Two

Define five mini-world Entities and five Relationships for a hospital database system.

Question Three

Draw an ER diagram for the following car sharing system:

In the car sharing system, a Car Match application has record of anyone who would like to share his/her car, known as a Car Sharer. An Administrator registers all the potential Car Sharers and with their first name, last name, home address, and date of birth. Each Car Sharer is also assigned a unique id. A Car Sharer can take policies issued by the Insurance Company. Each policy has a number, premium, and a start date. A Car Sharer needs to know the start and destination address of each Journey.

Question Four

Consider the following ER Diagram and fill the table by identifying the ER constructs in the diagram.

 

Constructs	Names
Strong Entities
Weak Entities
Relationships
Key Attributes