Part A

1. Select an organization where you think the implementation of database is very essential. A minimum of 5 entities should be listed along with the data and information that would be stored in database.

2.Draw tables to show the entities and the information stored.

3.Explain how this database is going provide the daily functions and list at least 6 advantages of using database.

Part B: Draw ER Diagram for the entities listed in Part A along with the attributes of the entitles. Relationships must also be created between entities that will help the organization to perform its functions.

Part C: Write SQL statements that include: Select, Update, Delete, From, Where, Ascending, Order By for at least 3 tables. Also show the tables before and after the execution of SQL queries.