coffee shop my sql database

Draw the ER Diagram for your data base.

Employ mapping technique to map ER to Relational database Schema$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.$