Database Management Systems

1)Model a relational database entity relationships (ER) modelling
-Consider a company named StoreCo that has the following Sample Data about Employees, Regions, and Stores:
->1) Write the business rules and identify the connectivity
->2) Identify the Primary Key and Foreign key for all The Entities
->3) Draw the Entity Relation Diagram using Crows Foot
2)Transform ER model into a logical relational database
->1) Write the SQL code that to Create the Tables (STORE, REGION, and EMPLOYEE)
3) Manipulate a relational database using SQL queries
->1) Write the SQL code that inserts the data into the tables
->2) Write the SQL code that will list all EMPLOEES
->4) Write the SQL code that will list all attributes for a EMPLOEE code of '6.
->5) Write a query to count the number of stores