coffee shop database my sql

Draw the ER Diagram for your database.

Employ mapping technique to map ER to Relational database Schema.

Q$2.$ IMPLEMENTATION Phase:

Develop your Database and tables in SQL Server Management Studio.

Your database must have queries that represent:

Insert command, you need to insert at least $7$ data Record into database tables.

At least $5$ Select statements to validate data model, the SQL command must include queries for $2$ or

more tables.

At least one update.

At least one delete option.

At least one Alter.

Q$3.$ Applying Constraint:

Your database must be in $3NF.$

The file should have the following format :

a$.$ The font size for text must be $14$

b$.$ The font style must be Time New Roman

c$.$ The line spacing must be $1\mathrm{.}5$ lines

d$.$ The document should be included Table of Contents.

e$.$ Titles and headings should be in bold.

f$.$ Indentation for each paragraph must be $1\mathrm{.}27.$