HomeworkLib
Question

Identify the Entities and Attributes and Draw the ER diagram. 1. Consider a mail order database in which employees take orders for parts from customers. The data requirements are summarized as follows: The mail order company has employees identified by a unique employee number, their first and last names, and a zip code where they are located Customers of the company are uniquely identified by a customer number. In addition, their first and last names and a zip code where they are located are recorded. · . The parts being sold by the company are identified by a unique part number. In addition, a part name, their price, and quantity in stock are recorded Orders placed by customers are taken by employees and are given a unique order number. Each order may contain certain quantities of one or more parts and their received date as well as a shipped date is recorded.

engineering   Computer-Science   
1 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

✔ Recommended Answer
Answer #1

Moil oden e.r bale Laat Lash ame Nome nome Coole Custom e aced acival grippig dje ed Order Skipg te. Number lecaived ice

3 0
Add a comment
Know the answer?
Add Answer to:
Identify the Entities and Attributes and Draw the ER diagram. 1. Consider a mail order database...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • I need help. Valley Vineyard Conceptual Model Case Read the case then create an entity-relationship diagram...

    I need help. Valley Vineyard Conceptual Model Case Read the case then create an entity-relationship diagram that captures the essence of the problem domain. Identify the entities (diagrammed in a rectangle box) Establish and label the relationships (diagrammed in a diamond) Determine the cardinalities Add the attributes, if you diagram is too busy the attributes can be on a separate page. Be sure to note any assumptions you have made. CASE: Valley Vineyard’s customers are mainly restaurants and wine shops...

  • c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I att...

    c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...

  • Design the entity relationship conceptual schema. Depict the ER diagram you have designed, outlining the entity...

    Design the entity relationship conceptual schema. Depict the ER diagram you have designed, outlining the entity types, relationship types, their respectives attributes, keys, structual constraints, and role names. In designing the entity relationship schema, make the initial conceptual design and the neccessary refinements after that. This will be a hospital database hospital, include patients, each patient will be either inpatient or outpatient and have a unique ID, first name, last name, address, city, zip code, phone number, and room number....

  • ER Modeling: Assignment In order to receive credit for this assignment, you must draw your ER...

    ER Modeling: Assignment In order to receive credit for this assignment, you must draw your ER model using a compute program and then turn in on the blackboard. Your ER model should include all of the necessary entity sets, relationships and keys, as well a weak entities and superclass/subclass relationships, if needed. A company decides to implement a software to monitor its employees' web surfing, and stores history of each employee's surfing in a database, as well as all of...

  • Please complete a high level conceptual model for Henry's Books. You need only show the entities,...

    Please complete a high level conceptual model for Henry's Books. You need only show the entities, relationships, cardinalities, and main attributes. All attributes are necessary. Walter Henry owns a chain of bookstores called Henry's Books. Henry gathers and organizes information about publishers, authors, and books. Each book has a unique code. The bookstore records the title, book description, style, price, and whether the book is a paperback. He also needs the number of units that reside in each of four...

  • Sample data is provided for the database for the sales system. Using the sample data, you...

    Sample data is provided for the database for the sales system. Using the sample data, you will determine the entities, key components of the entities, and business rules for the entities. Using the entities and business rules you will then create an ERD. Tasks: 1. For each entity provide the name, description, fields, data type, primary key, and foreign key. 2. For each direct entity type pair, provide the business rules. 3. Provide the ERD. Customer Table Customer ID, Last...

  • Use case diagram for Mail Order System Requirements(draw by use case diagram) This software system is...

    Use case diagram for Mail Order System Requirements(draw by use case diagram) This software system is developed to support mail order business operations. In particular software shall: - Keep track of sales (including orders, payments, and shipments). For each order a record shall be kept identifying the customer, the ZIP code, the salesperson, item ordered, the quantity, and amount due. - Record shall be kept for each customer who made a purchase in the past year. Such record shall include...

  • Consider a database schema with three relations: - Parts (pid:integer, pname:string, year:integer, price:integer) -Suppliers (sid:integer, sname:...

    Consider a database schema with three relations: - Parts (pid:integer, pname:string, year:integer, price:integer) -Suppliers (sid:integer, sname: string, state:string, zipcode:string) -Orders (pid:integer, sid:integer, quantity:integer) The description is as follows: a factory keeps a database with parts that it uses, the suppliers of those parts, and purchase orders. Each part is uniquely identified by pid. Each part has a string description pname, year of fabrication and price per unit. Parts are provided by suppliers, and each supplier is uniquely identified by sid....

  • 1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create...

    1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create the SQL script that will generate the data model Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their...

  • 3. (12 points) For each of the descriptions below, develop an ER diagram using draw.io. Create...

    3. (12 points) For each of the descriptions below, develop an ER diagram using draw.io. Create a new page in your draw.io file for each diagram and name them appropriately (e.g., “3a” and “3b”). Include entities, attributes (identifier, simple, composite, derived), relationships (cardinality, modality). a. A car company has a database where each car has an identifying serial number and a manufacturing completion date. Each car is an example of a certain model. All models have an identification number, name...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT