Hello, If you could help me with this I'd greatly appreciate it. Thank you.

 

 

Part 1
Use the following business rules to create a Crow's Foot Entity Relationship Diagram
(ERD). You need not use software to create the diagram. Label the symbols in the
Crow's foot diagram with the letter of the rule that relates to that symbol on the
diagram.
a. A department must have an employee, and can have many employees, but each
employee is assigned to at most one department
b. Some employees are not assigned to any department.
c. A division must have 1 or more departments, but each department is in exactly one
division.
d. An employee may be assigned to many projects, and a project need not have any
employees assigned to it, but can have many employees assigned to it.
e. An employee need not be assigned to a project.
f. Some employees are assigned their own parking space that only the designated
employee can use; some parking spaces are not assigned to any individual.
Part 1 will be graded so you can use those comments in order to complete Part 2. You
may submit a picture of your diagram or in hard copy.
Part 2
Create an Access database based on Part 1. You may do all the following using the
Access GUI rather than using SQL
1. Create a table for each entity shown in Part 1
2. Create additional tables to convert N:M relationships into 1:N relationships
3. Place foreign keys in tables as appropriate
4. Each table should have at least three columns (which can include foreign keys)
that are appropriate for that table - choose any appropriate columns
5. Specify properties for each column - data type, null status, default value (if
any), data constraints (if any) 6. The design should be normalized to Boyce-Codd Normal Form unless you
provide a justification for denormalization..
7. Create relationships that enforce referential integrity; you can do what you like
regarding cascade
For this part, you need only submit an Access database. As an alternative to creating
an Access database, you may submit the SQL in a text file to accomplish the above
steps.

• 1493170451-A2.docx

ComputerScienceExpert

(11)

Status NEW Posted 26 Apr 2017 01:04 AM My Price 8.00

-----------

Attachments

file 1493170452-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer