ZuoTi.Pro
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...

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

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

  • question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have...

    question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have all the needed details. You may make any reasonable assumptions but you have to state them clearly. ------ The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary, birth-date and home-address (Box, City, Zip). Each client (patient) has a unique Code, name, home-phone, work-phone, address, and birth-date. Each client is assigned to one dentist. All future visits will...

  • Help with database creation - create a visio ER diagram of the scenerio below.. thanks The...

    Help with database creation - create a visio ER diagram of the scenerio below.. thanks The registrar's office at Weber State University wants you to create a new database to support an future application that will help their department better keep track of the scheduled classes offered each semester, including the specific course sections and lecturers appearing in the schedule, and the students registering for courses according to the published schedule. Courses (think course catalog) may or may not be...

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
ADVERTISEMENT