You have been hired by $$JayMart$,$ a local supermarket to develop a database from scratch.

Your submission has to include the following $($Please see the attached sample project to get an idea what needs to submitted$)$

$1.$ ER Diagram or Relational Model

$2.$ SQL Code to create the mini world, entity $($tables$)$ with all the constraints $(15$ points$)$

$3.$ SQL Code to insert, delete and modify the tables: Insert, delete and modify for each table. Take into account the constraints $(15$ points$).$

$4.$ Sample SQL codes $($minimum $2)$ to retrieve data from tables $(10$ points$)$

What is in the sample project report?

This sample project report was submitted by one of the students from a previous class. The mini$-$world was a Social Network company

I have only included the part of the project that is relevant,

FAQs:

Q$1)$ What is this firm?

It is a imaginary supermarket. You need to come up with the details.

Q$2)$ Where do I get the data to insert in the tables?

Please come up with it$.5$ entries per tables is enough.

Q$3)$ What format do I submit my project?

The instructor should be able to copy the code and run it$.$ SQL$/$txt is most preferred.

Q$3)$ Can put screen shots?

Sure. If it helps to explain your mini world.

Q$4)$ What if there are no constraints in my database?

That means your tables are not related by the schema. Not a good design, since maintaining a valid state is almost impossible.