CSC555 System Requirements engineering
CIS111 Database Development
For this project you will be creating a database for a construction
etail 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.
. 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.
. For each table, list all of the data elements that will be needed. Make sure all
data elements are
oken 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 public
ii. The construction side of the company has the following
1. Three crews. Each crew has the following personnel
a. 1 electrician
. 1 plumber
c. 1. HVAC
2. Two inspectors
3. One director
4. Two schedulers
iii. The company has 2 locations, and a warehouse that serves all sites and
CIS111 Database Development
iv. The retail stores have one owner, 2
anch 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
1. NOTE. The Owner and
anch managers have a yearly salary.
$100K each, paid on a monthly schedule, all have no overtime
2. All others are paid hourly, $15 per hour, all are full time, with
v. They receive products from 6 different suppliers and sell to retail
customers, along with supplying the work crews.
a. The company wants to automate the following functions:
i. The incoming supplies
ii. The construction invoices (please review the customer sales invoice)
iii. Retail sales invoice (please review the supplier invoice)
iv. Employee information including payroll
v. Customer information
The 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 so I
have several days to evaluate and send back so you can make changes prior to the due date.
Sending the project for my review does not change the required due date. This is an individual
project. Similar submission will receive a zero.