Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 2.42PAE
Program Plan Intro
To create an ER diagram with the given information of student and adviser.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Requirement analysis:
Course evaluation must have a student, the students relation contains a unique student id, full name for each student, email address, phone number, address and date of birth.
For each course, the courses contain course id, course name and credit.
Each student can take many courses.
For each Instructor, the instructors contain id, name and email.
Each instructor can instruct many courses.
For each section, the sections contain section id, year and semester.
Students are able to evaluate the current courses.
ER-diagram: Please complete the ER diagram using Microsoft word.
Instructor
ID
Full name
Email
Student
ID
Full name
Email
Phone number
Address
Date of birth
Course
ID
Course title
Description
Credit
Section
ID
Year
Semester
Please Complete the diagram on MS word.
I tried to understand this question. it says:
An employee of JC Consulting created the query shown in Figure 2-48. He wants to list the client name, project ID, and task description for each task assigned to the projects for that client. Will this query be successful? If not, what needs to change in order for this query to work correctly?
Can someone help me with this problem?
Considering the un-normalized relational table PROJECT below:
PROJECT (Project Title, EmpeName, ManagerName, Location, Hours Work,
ManagerPhone)
The attributes of PROJECT table satisfy the following properties:
Each project has many employees,
Each employee may involve in one or more projects,
Projects are managed by managers; there are many managers in the
company, hence a project may be assigned to any one of the managers, but
each manager manages only one project.
Each project is located in a specific location,
The number of hours an employee works at each project is determined by a
project title and the name of an employee.
Each manager has a telephone number.
Normalize the relational table PROJECT into a minimal number of relational tables
in BCNF. Use the functional dependencies to prove that each one of the relational
tables obtained from the decomposition of the original table is in BCNF.
Chapter 2 Solutions
Modern Database Management
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Match the following terms and definitions....Ch. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Give an example, Other than those described in...Ch. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - Prob. 2.24PAECh. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - Prob. 2.29PAECh. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Figure 2-27 represents a situation of students who...Ch. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.46PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
Knowledge Booster
Similar questions
- Normalise the following table named 'PROPERTY' to remove modification anomalies showing all steps for 1NF, 2NF and 3NF. State any necessary assumptions to support your answer. Important : Provide appropriate justification for each normalisation step. PROPERTY (clientNo, clientName, propertyNo, propertyAddress, owner, rent, rentStart, rentFinish) Primary Key: clientNo, propertyNo Given that the following dependencies exist: clientNo -> clientNamepropertyNo -> propertyAddress, owner, rentclientNo, propertyNo -> rentStart, rentFinisharrow_forwardExamine the table shown below. This table represents the hours worked per week for temporary staff at each branch of a company. (a) The table shown below is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table. Using the data shown in this table, the student should provide examples of how insertion, deletion, and update anomalies could occur.arrow_forwardConsidering the un-normalized relational table PROJECT below: PROJECT (ProjectTitle, EmpeName, ManagerName, Location, HoursWork, ManagerPhone) The attributes of PROJECT table satisfy the following properties: Each project has many employees, Each employee may involve in one or more projects, Projects are managed by managers; there are many managers in the company, hence a project may be assigned to any one of the managers, but each manager manages only one project. Each project is located in a specific location, The number of hours an employee works at each project is determined by a project title and the name of an employee. Each manager has a telephone number. Normalize the relational table PROJECT into a minimal number of relational tables in BCNF. Use the functional dependencies to prove that each one of the relational tables obtained from the decomposition of the original table is in BCNF.arrow_forward
- Consider the table: STAFF_MEETING (EmployeeName, ProjectName, Date) The rows of this table record the fact that an employee from a particular project attended a meeting on a given date. Assume that a project meets at most once per day. Also, assume that only one employee represents a given project (think of it as a project leader) but that employees can be assigned to multiple projects. State the functional dependencies in STAFF_MEETING. Transform this table into one or more tables in BCNF. State the primary keys, candidate keys, foreign keys, and referential integrity constraints.arrow_forwardA rental car company divides its cars into four categories: small, mid-size, full-size, and sport utility. The agency wishes to collect the following information from all vehicles: Vehicle, Make, Model, Year, and Color are all required. There are no distinguishing characteristics for any of the four vehicle classifications. Rents is a connection between the entity type vehicle and the entity type client. There is no one-to-one connection between any of the four vehicle types and any entity type. Would you think about making a supertype/subtype connection for this problem? If so, why or why not?arrow_forwardInstructions: Create a dimensional model for a particular business process involving gym membership. A customer can sign up for a membership of say one, three, six or twelve months. I want to make it easy to query to identify current members, members who expired in the last month, members who renewed in the last month, those who are pending expiry etc. If I have a basic model with a fact table representing a gym membership say start_date_key end_date_key membership_attribute_key customer_atrribute_key fee with associated dimension table for date, membership attributes such as length, customer attributes and so forth. On a particular day, the active members are those with a start date before the day and an end date after that day. Those who will expire next month are those where the end date is in a particular date range.arrow_forward
- create an ER tablearrow_forwardList the changes you would need to make to your answer for Question 11 if the requirements change so that you must store the year and the semester in which a student took a course and received a grade.arrow_forwardWhat type of relationship can’t be stored in a relational database? Why?arrow_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_forwardDetermine the highest normal form (1NF, 2NF, 3NF, or BCNF) for each one of the following six relations. Notice that the primary key of each relation is underlined.) 1 2 3 4 5 6 Relations Work (EmpNumber, ProjectNumber) Work (EmpNumber, ProjectNumber, ManagerSSN) Given that a project has one manager only. Work (EmpNumber, ProjectNumber, HoursPerWeek) Work (EmpNumber, ProjectNumber, EmpName, Location) Given that a project is located in one location only. Work (EmpNumber, ProjectNumber, Location) Given that a project is located in one location only. Work (EmpNumber, ProjectNumber, Location) Given that a location has one project only. Answersarrow_forwardQuestion 7 Which one of the following is an instance of the STUDENT entity? A general description that applies to all students? A label of a single attribute that each student has Ms. Brownwood with a student ID 34523443 Data regarding the grade that Ms. Brownwood earned in a section of course CS 350. All students in Mr. Derby's section of CS 350. Question 8 Identify the notation for a multivalued attribute: Area of interest {Area of interest} [Area of interest] Areas of interest None of the abovearrow_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
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning