SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 26 Mar 2018 My Price 10.00

Crow's Foot Entity Relationship Diagram

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
Create a table for each entity shown in Part 1
Create additional tables to convert N:M relationships into 1:N relationships
Place foreign keys in tables as appropriate
Each table should have at least three columns (which can include foreign keys) that are appropriate for that table - choose any appropriate columns
Specify properties for each column - data type, null status, default value (if any), data constraints (if any)
The design should be normalized to Boyce-Codd Normal Form unless you provide a justification for denormalization..
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.

 

 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 26 Mar 2018 03:03 PM My Price 10.00

  ----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------  ----------- 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-----------

Not Rated(0)
Relevent Questions