Creating a database

CIS111 Database Development Project 1For this project you will be creating a database for a construction/retail Company. The company wants to automate some services, so you are tasked to architect the database.1. How to submit your assignment:a. This individual assignment will be submitted in report format.b. The submission must have the following:i. A cover sheet with your name, and your database name.ii. The project requirements below.c. The assignment is due no later than the date identified in the Moodle announcement. You cannot start on project 2 until this project has been completed. A minimum sore of a 60 is required on this project before you can start project 2.2. The project requirements:a. Determine the entities (tables) that will be needed. You can use the sheet similar to the sheet we used in class. A blank sheet is available on Moodle. You will need around 7 – 10 tables to properly complete this project.b. For each table, list all of the data elements that will be needed. Make sure all data elements are broken down to its smallest component, but not more, or less, than 3rd normal form. . Having one or two attributes for a table will not work. You must have enough attributes to adequately describe the entity.c. The data dictionary that outlines ALL of your data elements. A blank excel spreadsheet is available on Moodle.d. Create an entity relationship diagram for your database. No hand drawn diagrams will be accepted. There are several software programs that can assist. You can use Microsoft Visio, Oracle Data Modeler, or Erwin Data Modeler. DO NOT use Microsoft SQL server for project 1, as your project will not be accepted.e. Identify primary/foreign keys for the tables.3. Company Information:a. The company has the following characteristics:i. Two retail stores sell to the general publicii. The construction side of the company has the following1. Three crews. Each crew has the following personnela. 1 electrician b. 1 plumber c. 1. HVAC2. Two inspectors3. One director4. Two schedulersiii. The company has 2 locations, and a warehouse that serves all sites and construction crews.
CIS111 Database Development Project 3iv. The retail stores have one owner, 2 branch managers, 4 cashiers, 2 Chefs, 4 Stock personnel, and 2 administrative assistants (one per location). The employees are distributed equally between the two locations. The owner sits at the main branch.1. NOTE. The Owner and branch managers have a yearly salary. $100K each, paid on a monthly schedule, all have no overtime available.2. All others are paid hourly, $15 per hour, all are full time, with Overtime available.v. They receive products from 6 different suppliers and sell to retail customers, along with supplying the work crews.4. Automation:a. The company wants to automate the following functions:i. The incoming suppliesii. The construction invoices (please review the customer sales invoice)iii. Retail sales invoice (please review the supplier invoice)iv. Employee information including payrollv. Customer informationThe project contents, drawing and documentation are due per Moodle announcement. You cannot start project 2 without submitting project 1 and received a grade over 60%. You can submit earlier for review, but keep in mind the review submissions need to be soon enough s back so you not change the required due date. This is an individual project. Similar submission will receive a