Draw an e-r diagram for situations

Assignment Help Software Engineering

Reference no: EM13695844

Can you prepare E-R Diagrams for the given questions?

Question: Draw an E-R Diagram for each of the following two situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw each of the subsequent 2 situations using the tools you have studied in chapter 2.

Scenario 1: A company has a number of employees. The attributes of EMPLOYEE include Employee ID (identifier), Name, Address, and Birthdate. The company also has several projects. Attributes of PROJECT include Project ID (identifier), Project Name, and Start Date. Each employee may 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.

Scenario 2: A book is identified by its ISBN number, and it has a title, a price and a date of publication. It is published by a publisher, which has its own ID NUMBER and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time. A book is written by one or multiple authors. Each author is identified by an author number and has a name and date of birth.

Each author has either one or multiple books. For this Scenario, you must create the identifiers for the attributes listed. Make sure to use the guidelines for creating good identifier names.

Can someone provide the answer with reference to software engineering?

Reference no: EM13695844

Questions Cloud

What is the current status of the labor movement : Your response should be at least 200 words in length. You are required to use at least your textbook as source material for your response. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompa..

Create a function that multiplies numeric matrices : Create a function that multiplies numeric matrices on an element-by-element basis.

Function that normalizes a numeric vector : Create a function that normalizes a numeric vector (returns a unit vector).

Calculator for elementary school children : Write a program that is designed as a calculator for elementary school children. It will calculate addition, subtraction, multiplication, and division.

Draw an e-r diagram for situations : Draw an E-R Diagram for each of the following two situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw each of the subsequent 2 situations using the tools you have studied in chapte..

Calculate the amount of profit and loss : Calculate the amount of profit and loss. Also if Profit then display the smiley face, if loss then display sad face and if break even then confused face.

Construct an finite automata that accepts all binary strings : Construct an FA (finite automata) that accepts all binary strings with an even number of 0's and the number of 1's is a multiple of 3.Provide the answer of given question and also give details.

What is the values of k and a in mark houwink : What is the values of k and a in mark houwink equatuion at room temp.

How many grams of ammonia are in the flask : Question- A 3.00-L flask is filled with gaseous ammonia, NH3 . The gas pressure measured at 28.0?C is 1.15atm. . Assuming ideal gas behavior, how many grams of ammonia are in the flask

User Account

All Pages