i want a my sql database for a coffee shop

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.$