User Account

All Pages

Draw an entity relationship diagram (erd)

Assignment Help Database Management System
Reference no: EM13242263

Answer the following question; save the work as Exam2_Part1_your name and submit it via Blackboard.

Draw an entity relationship diagram (ERD) for the following situation:

A company has a number of employees.  Each employee is identified by an Employee_Id.  The company wants to store Employee_Name, Employee_Address, and Employee_BirthDate in the database.  The company also has several projects.  Each project is identified by a Project_Id.  The company wants to store Project_Name and Project_StartDate in the database.  Each employee must be assigned to one or more projects, or may not be assigned to a project.  A project must have at least one employee assigned and may have any number of employees assigned.  An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing_Rate) for each employee when assigned to a particular project. 

Please use Visible Analyst to draw the ERD.  Copy and paste the diagram in the Word document Exam2_Part1_YourName.        Grading Rubric: 

Criteria

Points

Entities

2

Attributes and Primary Keys

2

Relationships

2

Cardinalities

2

Notations and Symbols

1

Using Visible Analyst

1

Total

10

 

Reference no: EM13242263

Questions Cloud

What is the view of god and morality in the koran : What is the view of GOD and MORALITY in the Koran? How do these views compare with the Hebrew and Christian texts?
What was the covenant : What was the "Covenant" that God had with the Hebrew people as described in your readings? HOW ARE THE "COVENANT" AND THE TEN COMMANDMENTS CONNECTED TO EACH OTHER?
Compare david’s oath of horatii o thomas gericault’s raft : Compare David’s Oath of the Horatii, pg. 299 (305) to Thomas Gericault’s Raft of the Medusa on pg. 61 (65). How are these paintings different?
Powerful movements that transformed european society : Discuss the powerful movements that transformed European society during the early modern era. Briefly describe the origin of each, how it affected society as a whole. Which had the most impact? Why?
Draw an entity relationship diagram (erd) : Draw an entity relationship diagram (ERD) for the following situation: A company has a number of employees.  Each employee is identified by an Employee_Id.  The company wants to store Employee_Name, Employee_Address, and Employee_BirthDate in the dat..
Compare this bach piece to a gregorian chant : Bach's Brandenberg Concerto no.2 in F Major. How can you describe this music? Compare this Bach piece to a Gregorian Chant. How has music changed?
Characterists of the neoclassical style : The oath of the horatii by david how does this painthing embody four of the five formal characterists of the neoclassical style as found on this website?
Rembrandt''s masterpiece : Rembrandt's masterpiece, The nightwatch how is subject of this painting different from what would be hanging in the palaces and cathedrals of Spain,Italy, and France?
What provisions of the emperor justinian''s law code : The Roman Empire was, for the most part, a state based on the rule of law. This is one of the legacies of Roman civilization. What provisions of the Emperor Justinian's Law Code (in your text) are also similar to laws that we have today? (Discuss as ..

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd