Database System

Q1.The traffic police department in Islamabad is looking for a person who can develop Road Accidents Information System (RAIS). It will be a database application to manage information of the road accidents. The application will store information about road accidents like when and where it happened? Information about the vehicles which met accident like vehicle type, vehicle number, make and model, vehicle owner. Information like person name, contact number, address, gender, and age are required about each person who either died, injured, or remained safe in that accident. The persons are divided into 3 categories: Kids, teenagers, and adults. The application should store information about the cause of accident. You can add more information of your choice to make the application more meaningful. Tasks to do:

1) Create Conceptual Database Design using ER diagram.

2) Create Logical Database Design by converting ER diagram into Relational Model