Great Deal! Get Instant $25 FREE in Account on First Order + 10% Cashback on Every Order Order Now

CSC555 System Requirements engineering CIS111 Database Development Project 1 For this project you will be creating a database for a construction/retail Company. The company wants to automate some...

1 answer below »

CSC555 System Requirements engineering
CIS111 Database Development
Project 1


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
construction crews.
CIS111 Database Development
Project 3

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
anch.
1. NOTE. The Owner and
anch 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 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.
Answered 1 days AfterMar 19, 2022

Solution

Neha answered on Mar 21 2022
69 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here