Draw an erd containing the order and customer entity

Assignment Help Database Management System
Reference no: EM13773104

PROBLEM

The problem emphasized correct usage of the Crow's Foot notation and application of the diagram rules. This emphasis is consistence with the pedagogy of the chapter. The more challenging problems in Chapter 6 emphasize user requirements, diagram transformations, design documentation, and schema conversion. To develop a good understanding of data modeling, you should complete the problems in both chapters.

1) Draw an ERD containing the order and customer entity types connected by a 1-M relationship from customer to order. Choose an appropriate relationship name using your common knowledge of interactions between customers and orders. Define minimum cardinalities so that an order is optional for a customer and a customer is mandatory for an order. For the customer entity type, add attributes CustNo (primary key), CustFirstName, CustLastName, CustStreet, CustCity, CustState, CustZip, and CustBal (balance). For the order entity type, add attributes for the ordNo (primary key), OrdDate, OrdName, OrdStreet, OrdCity, OrdState, OrdZip. If you are using a data modeling tool that supports data type specification, choose appropriate data types for the attributes based on your common knowledge.

2) Extend the ERD from problem 1 with the Employee entity type and a 1-M relationship from Employee to order. Choose an appropriate relationship name using your common knowledge of interactions between employees and order. Define minimum cardinalities so that an employee is optional to an employee. For the Employee entity type, add attributes EmpNo (primary key), EmpFirstName, EmpLastName,EmpPhone,EmpEmail,EmpCommRate (commission rate), EmpDateName. If you are using a date modeling tool that supports data type specification, choose appropriate data types for the attributes based on your common knowledge.

3) Extend the ERD from problem 2 with a self -reference 1-M relationship 1-M relationship involving the Employee entity type. Choose an appropriate relationship name using your common knowledge of organizational relationships among employees. Define minimum cardinalities so that the relationship is optional in both directions.

4) Extend the ERD from problem 3 with the product entity type and an M- N relationship between product and order. Choose an appropriate relationship name using your common knowledge of connections between products and orders. Define minimum cardinalities so that an order is optional to a product, and a product is mandatory to an order. For the product entity type, add attributes ProdNo (primary Key), ProdName, ProdQOH, ProdPrice, and ProdNextShipDate. For the M- N relationship, add an attribute for the order quantity. If you are using a date modeling tool that supports data type specification, choose appreciation data types for the attribute data types for the attributes based on your common knowledge.

5) Revise the ERD from problem 4 by transforming the M-N relationship into an associative entity type and two identifying, 1-M relationship.

Reference no: EM13773104

Questions Cloud

Prepare a demonstration of the aldol : Prepare a demonstration of the Aldol - What are the TLC values (Rf) for (a) starting Materials: (b) Products:
New city is considering building a recreation center : New City is considering building a recreation center. The estimated construction cost is $12 million with annual staffing and maintenance costs of $750,000 over the twenty year life of the project. At the end of the life of the project, New City expe..
Applications of nuclear medicine : What type of radiation is typically exploited in most nuclear medicine procedures?
Purpose of quality management in the health care industry : What is the purpose of quality management in the health care industry? And why is it needed? Why do various health care stakeholders define the quality of care differently?
Draw an erd containing the order and customer entity : Draw an ERD containing the order and customer entity types connected by a 1-M relationship from customer to order. Choose an appropriate relationship name using your common knowledge of interactions between customers and orders.
Provide a description of higher ranking countrys major trade : Provide a brief description about the higher ranking country's major trade. Analyze the higher ranking country's report rankings across the board, and speculate on how this country got to its current position.
Create a schematic or flowchart to illustrate how to incorpo : You are the project manager at a state-supported public healthcare facility. Because of the success of your organization, a local organization has donated a state-of the-art magnetic resonance imaging machine that is not available anywhere else in th..
What is the name date and location of the disaster : What is the name, date, and location of the disaster? What are the changes or developments that occurred in the field of emergency management as a result of this event
The significance of air pressure to the earth''s weather : When comparing the density of an object with the density of water, how do we determine if an object floats or sinks in water?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Write the proper sequence of activities in the design

Write the proper sequence of activities in the design of a video rental database. The initial ERD is shown in above (or refer to textbook figure 9.9). The design must support all rental activities, customer payment tracking, and employee work sche..

  Design pattern for web based database interfaces

We have implemented the MVC design pattern for Web based database interfaces. However, there are other design patterns that may be directly applicable to PHP programming, or web programming in general.

  Draw a complete entity relationship model

Discuss any FOUR reports that would be generated from the data model - Draw a complete Entity Relationship (ER) model using data model notation that you are familiar.

  Create one table representing normalized design

Create one table representing normalized design (3NF) for the important objects and their attributes in a textbook catalogue and accounting office at a university book store

  Process the weather data with data mining techniques

Process the weather data for Auckland and Invercargill in the given dataset (monthly readings) and-focusing in particular on temperature related data-experiment with various data mining techniques

  Describe product characteristics and deliverables

Develop a scope statement for the project and describe product characteristics and deliverables.

  Triggers important in database systems

What are triggers used for, and why are they important in database systems? Provide an example of a situation where a trigger would be appropriate.

  Optimizing sql server query performance how to optimizing

how to optimizing sql server query performance? when optimizing your database server you need to tune the performance

  Design visio diagram

Create a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).

  Improve decision making for management

Prepare a brief of at least 1,400 words for Kudler Fine Foods management in which you address

  Discuss common input - output technologies

Create a Microsoft Word table that identifies the advantages, disadvantages, computer requirements, initial costs, and future savings for an organization considering an engagement in virtualization.

  What is the oldest log record we need to retain

If a bounded amount of stable storage is used for the log, how can we always ensure enough stable storage to hold all log recordswritten during restart?

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!

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