HomeworkLib
Question

I wanted to see the ER diagram for chapter 3, problem 32 in Fundamentals of database...

I wanted to see the ER diagram for chapter 3, problem 32 in Fundamentals of database systems text. I have created the diagram, but I am unsure on the relationships.

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

Homework Answers

Answer #1

If any problem in understanding please comment below.

Question I found in chapter 3 . problem 32 is

Answer:

Given that customer places an order of part . Customer can order many parts and many parts can be ordered by many customers. So customer and parts relation (order relation) is m : n. Since customer has to order atleast one part . All parts need not to be ordered by customer , So full participation on customer side and partial participation on part side.

Customer order is taken by employee. A customer can give many orders but one order at a time is taken by only one employee. So N:1 relationship. Customer order has to be taken by atleast one employee so customer full participation. Some employees may not take orders because of less number of orders , so employee partial participation.

0 0
Add a comment
Know the answer?
Add Answer to:
I wanted to see the ER diagram for chapter 3, problem 32 in Fundamentals of 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

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Accounting Info Systems A. True B. False 10. Tables in a relational database are documented by a data flow diagram. A. True B. False 11. In database design, the recommended step after ER Diagram...

    Accounting Info Systems A. True B. False 10. Tables in a relational database are documented by a data flow diagram. A. True B. False 11. In database design, the recommended step after ER Diagram is A. Relational schema B. Database implementation C. Either of the above D. None of the above The next 2 questions refer to binary relationships. 12. One to many ER have diagram will havetables in the relational schema. A. One B. Two C. Three D. More...

  • I would like to make an er diagram for a hospital database system and underline key...

    I would like to make an er diagram for a hospital database system and underline key attributes for entity sets, specify relationships with arrowheads. I chose Patient, Doctor, Room, Nurse, Medicine and Bill as entities.

  • Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage ...

    Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage data for athletes athletic game. Requirements are as follows: Each participating team has a name and a manager. Each athlete has a unique athlete ID, and is also described by first name and last name, gender and age. A team has many athletes but an athlete only belongs to one team. Each sport has a unique code and some sport name....

  • ER Diagrams (Database Management Systems) Problem 2: Produce an ER diagram for the following description. A...

    ER Diagrams (Database Management Systems) Problem 2: Produce an ER diagram for the following description. A spreadsheet has a unique le location, composed of a path and a le name. A spreadsheet is composed of a set of worksheets, each having a name, unique to that spreadsheet, and a set of cells. Each cell has a unique location within the worksheet, designated by (row, column), and a value. Problem 3: You are given a description and an ER diagram below....

  • This question is from the subject: Database Systems QUESTION 4 Consider the ER Diagram. Which of...

    This question is from the subject: Database Systems QUESTION 4 Consider the ER Diagram. Which of the following are valid schemas that result from transforming this diagram into a simplified schema (i.e., after relationships are merged)? Select all that apply. course name phone address name Chefs signature Dishes Member 1 main Team Ingredients name points name 1. Team(name, points) 2. Signature(chef, dish) FK chef REF Chefs(name) FK dish REF Dishes(name) 3. Chefs(name,phone,address,team) FK team REF Team(name) 4. Ingredients(name, dish) FK...

  • I need to draw an ER diagram for a future database necessary to hold application data...

    I need to draw an ER diagram for a future database necessary to hold application data for students wishing to apply for a programming internship job on campus. The students will provide the following information on the application: studentID_Number, first name, last name, email, phone number, address, city, state, postal code, major, currently enrolled in school?, expected date of graduation, web framework of choice, list of programming languages in which the student is proficient, SAT score, ACT score, GPA, 4...

  • 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...

  • For chapter 5 problem 13 for Fundamentals of Digital Logic with Verilog Design, I am curious...

    For chapter 5 problem 13 for Fundamentals of Digital Logic with Verilog Design, I am curious to know where the equation 2^n if n is the number of fan ins comes from. This equation was used in the solution to answer the number of gates required due to the fan in requirement.

  • Problem 1 : Movies ER Model Consider a Database that keeps track of scenes filmed for...

    Problem 1 : Movies ER Model Consider a Database that keeps track of scenes filmed for different movies. A movie uses a screenplay (or story) which is broken down into scenes. The movie will also have the same scenes because it is a movie of that screenplay. Not all screenplays in the database become movies, but every movie is of a particular screenplay. Also, a screenplay is used for only one movie. That is, there are not two different movies...

  • Database Analysis and Design (ER diagram) After the requirement collection and analysis phase the software project...

    Database Analysis and Design (ER diagram) After the requirement collection and analysis phase the software project of a database application about a company is described as follows: 1. The company is organized into departments. Each department has a name, an unique number, and a particular employee who manages the department. We keep track of the start date when the employee began managing the dept. A dept may have several locations. 2. A dept controls several projects, each of which has...

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