Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 17P
Program Plan Intro
The Crow’s Foot ERD for the relationship between THEATER, MOVIE, REVIEW and REVIEWER is given below.
In the given model, the connectivity’s “1” is represented by a short line segment, and “M” is represented by the three-pronged crow’s foot and the relationship name “shows”, “receives”, and “writes” is written above the relationship line.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Write the business rules that are reflected in the ERD shown in Figure P2.15. (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the “1” to the “M” side, regardless of the orientation of the ERD components.)
FIGURE P2.15 THE CROW’S FOOT ERD FOR PROBLEM 15
Given the following relation that stores details of employees and their projects:
ProjectID
EmployeeName
EmployeeSalary
100-A
Salim Housni
2000
100-A
Taleb Maashani
1800
100-B
Taleb Maashani
1800
200-A
Salim Housni
2000
200-B
Salim Housni
2000
200-C
Salim Housni
1350
200-C
Taleb Maashani
1800
200-D
Salim Housni
1350
If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE
ProjectID --> EmployeeName (....)
ProjectID --> EmployeeSalary (....)
ProjectID , EmployeeName -->EmployeeSalary (....)
EmployeeName --> EmployeeSalary (....)
EmployeeSalary --> ProjectID (....)
EmployeeSalary --> EmployeeName , ProjectID (....)
Please answer.
Chapter 2 Solutions
Database Systems: Design, Implementation, & Management
Ch. 2 - Prob. 1RQCh. 2 - What is a business rule, and what is its purpose...Ch. 2 - How do you translate business rules into data...Ch. 2 - Prob. 4RQCh. 2 - Explain how the entity relationship (ER) model...Ch. 2 - Prob. 6RQCh. 2 - Prob. 7RQCh. 2 - Prob. 8RQCh. 2 - Prob. 9RQCh. 2 - Prob. 10RQ
Ch. 2 - What is a relationship, and what three types of...Ch. 2 - Give an example of each of the three types of...Ch. 2 - What is a table, and what role does it play in the...Ch. 2 - Prob. 14RQCh. 2 - Prob. 15RQCh. 2 - Prob. 16RQCh. 2 - Prob. 17RQCh. 2 - Prob. 18RQCh. 2 - Prob. 19RQCh. 2 - Prob. 20RQCh. 2 - Prob. 21RQCh. 2 - Prob. 22RQCh. 2 - Prob. 23RQCh. 2 - Prob. 1PCh. 2 - Prob. 2PCh. 2 - Prob. 3PCh. 2 - Prob. 4PCh. 2 - Prob. 5PCh. 2 - Using Figure P2.6 as your guide, work Problems 68....Ch. 2 - Prob. 7PCh. 2 - Prob. 8PCh. 2 - Typically, a hospital patient receives medications...Ch. 2 - Prob. 10PCh. 2 - Prob. 11PCh. 2 - Prob. 12PCh. 2 - Prob. 13PCh. 2 - Prob. 14PCh. 2 - Prob. 15PCh. 2 - Prob. 16PCh. 2 - Prob. 17P
Knowledge Booster
Similar questions
- What is the difference between a PRIMARY KEY constraint and a UNIQUE constraint?arrow_forwardGiven the following relation that stores details of employees and their projects:arrow_forwardGiven the following relation that stores details of employees and their projects: ProjectID EmployeeName EmployeeSalary 100-A Salim Housni 2000 100-A Taleb Maashani 1800 100-B Taleb Maashani 1800 200-A Salmi Alrisi 2000 200-B Salmi Alrisi 2000 200-C Salmi Alrisi 1350 200-C Taleb Maashani 1800 200-D Salim Housni 1350 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. ProjectID > EmployeeName | ProjectID > EmployeeSalary| ProjectID, EmployeeName > EmployeeSalary | EmployeeName > EmployeeSalary | EmployeeSalary > ProjectID EmployeeSalary → EmployeeName , ProjectIDarrow_forward
- Write relationship and cardinality constraints which is in list. You need to make any assumptions I need querryarrow_forwardIdentify week entity in the following scenario: "Students registered in a particular course section of a specific course". AS. A. Course Section B. Course C. Student D. Register Foc 耳 hp f10arrow_forwardIn the attached diagram, which of the following statements are true? primary key for section is course_id, sec_id, semester, year primary key for section is equivalent to the primary key for course unioned with the discrimator section is a weak entity set whose existence depends on course the discrimator of section is sec_id, semester, yeararrow_forward
- Use the Information below and create a sequence diagram for the use case. Name: Buy Parts Actor: Customer/Store Associate Description: This use case describes the process used to buy parts at the auto parts dealer. Successful Completion: 1. Customer requests auto part 2. Store Associate checks on availability of part 3. Part is available and customer pays cost 4. Customer receives part and stock is adjusted 1. Customer requests auto part 2. Store Associate checks on availability of part 3. Part is not available and customer selects to order part or no part 4. Customer receives part and stock is adjusted (if alternate part ordered) or customer leaves with no part Alternative: Pre-Condition: Customer wants to purchase part Post-Condition: None Assumptions: Nonearrow_forwardCreate a Crow's Foot ERD to include the following business rules for the ProdCo company:a. Each sales representative writes many invoices.b. invoice is written by one sales representative.c. Each sales representative is assigned to one department.d. Each department has many sales representative.e. Each customer can generate many invoicesd. Each invoice is generated by one customerarrow_forwardWrite out a relational schema for the following ERDarrow_forward
- Consider the System Description of question no 2. All the student are advising to reply the following queries, keeping in view the above mention system description title as "Dream Home branch offices case study". (a) List the details of branches in a given city. (b) Identify the total number of branches in each city. (c) List the name, position, and salary of staff at a given branch, ordered by staff name. (d) Identify the total number of staff and the sum of their salaries. (e) Identify the total number of staff in each position at branches in Glasgow. (f) List the names of staff supervised by a named Supervisor. (g) List the property number, address, type, and rent of all properties in Glasgow, ordered by rental amount. (h) Create a branch and staff relationship in view of joint perspective. (1) List the details of properties for rent managed by a named member of staff. G) Identify the total number of properties assigned to each member of staff at a given branch. (k) List the details…arrow_forwarda) Put the following relation in BCNF: STUDENT_ACTIVITY STUDENT_ACTIVITY (StudentID, StudentName, Activity, ActivityFee, AmountPaid) StudentID StudentName Activity ActivityFee AmountPaid 1 100 Jones Golf 65.00 65.00 2 100 Jones Skiing 200.00 0.00 3 200 Davis Skiing 200.00 0.00 4 200 Davis Swimming 50.00 50.00 5 300 Garret Skiing 200.00 100.00 6 300 Garrett Swimming 50.00 50.00 7 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00 b) Put the following relation in BCNF: Student(SSN, sName, address, HScode, HSname, HScity,GPA, priority) Assuming a student can attend more than one high school, and priority is determined by GPAarrow_forwardA course instructor will assign grades from (A, B+, B, C+, C, D+, D, EJ. What is the minimum number of grades that must be assigned in order to guarantee at least one of the grades has been assigned 10 times.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage