$1.$ Using Entity$-$Relationship $($E$-$R$)$ Model, a data modeling technique, create data model.

Use Microsoft Visio to draw your data model.

a$.$ Make sure your E$-$R model accurately represents all entities and attributes,

including weak$/$strong entities and super$-$type$/$sub$-$type entities.

b$.$ Make sure your E$-$R model accurately represents all relationships.

c$.$ Make sure all entities and attributes are labeled accurately according to the

business problem description.

d$.$ Make sure to show all maximum and minimum cardinalities.

$2.$ Take the E$-$R diagram and transform the data model to a database design model. Using

Microsoft Visio to draw your database design model.

a$.$ Perform normalization if needed.

b$.$ Make sure to transform all entities accurately.

c$.$ Make sure to specify primary key, candidate key, and foreign key accurately.

d$.$ Make sure to specify attribute properties $($null status, data type, default value, and

data constraints$).$

e$.$ Make sure all relationships are appropriately drawn and marked.

f$.$ Make sure to transform all maximum and minimum cardinalities.

$3.$ Write schemas for your database design.

$4.$ Using Microsoft SQL Server, implement the database design and schemas that were

developed in step $2$ and $3.$ You must use SQL syntax to create tables. $($NOTE: I have

already created database with your own name$)$

a$.$ Make sure all field properties are appropriately coded.

b$.$ Make sure all primary key, foreign key, alternate key are appropriately coded.

c$.$ Make sure all constraints are appropriately coded.

d$.$ Make sure restrictions are appropriately coded.

e$.$ For each relational table, insert at least $10$ records. The records can be fictitious.

You must use SQL syntax to insert data into the relational database.

$5.$ Write at least ten queries that are relevant to your project scenario.

a$.$ There should be at least one query using INNER JOIN.

b$.$ There should be at least one query using OUTER JOIN.

c$.$ There should be at least one query using sub$-$query.

d$.$ There should be at least one query joining three or more tables