Design a database for an enterprise of your choice. Include the following in your report.

$1.$ A description of the enterprise. What is the purpose of the database? $--$ about $(1)/(2)$ page.

$2.$ Identify at least four major entities. Provide a list of the entities and a short description

for each entity.

$3.$ Draw a complete ER diagram showing

a$.$ The entities with their attributes, and primary keys

b$.$ Relationships among the entities, and their attributes

c$.$ Cardinality constraints

d$.$ Total $/$ partial participation

e$.$ Weak entities and discriminator

$4.$ Reduce the ER diagram to relational schemas.

$5.$ Are the schemas in BCNF$?$ If not, decompose them into BCNF$.$