Modern Database Management
13th Edition
ISBN: 9780134773650
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 solutionStudents 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.
Create an ER Model for the following requirements:
A car has a make, model and year.
A registration has a county and date.
A person has an address and an age.
A car may be owned by a person.
A car may be registered to an owner.
Draw an ERD for the following requirements
There are many air conditioners in EMU. Each air conditioner has a unique inventory number. We have to store the model and make of each air conditioner. Each air conditioner is located in a room. Each room is identified by a unique roomid. We also store the capacity and type of the room. Each air conditioner is serviced twice a year. For each service, we need to store the date of the service and the name of the person who performed the service.
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
- 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.arrow_forwardA college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?arrow_forwardThe entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No of Years represents the number of years the student has engaged in this activity. A given student may engage in more than one activity. Draw an ERD for this situation. What attribute or attributes did you designate as the identifier for the STUDENT entity? Why?arrow_forward
- Entity Relationship Diagram of the business, as shown in the case. Completely and correctly specify all Entities, Relationships and Attributes Order: has one or many items; half by member half by anonymous member (no member number)Has: order number, each order item has total cost (with and without gst), number of store, cashier who took the order, member number (if provided), date on which the order was places, and, if the order is not picked up in-person, the date on which the order is shipped. Order-Item (one of the 1600 products):to identify: useorder number as well as a small “item sequence number” (which is unique within each order). product number, quantity ordered and the actial "unit price paid" If a valid member number is on the order, the system should use the product’s special “member price”, otherwise the product’s “regular price” is used. The average order includes 11 distinct order-items. Member (places 5 orders per month on avg):last name, given names, email…arrow_forwardI 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?arrow_forwardAll entity names, relationship names, and attribute definitions must be correct.arrow_forward
- Considering 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_forwardA ternary relationship is a relationship which includes Select one: O a. Two entities O b. Three entities Oc. One entity O d. Four entitiesarrow_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
- Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher publishes one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author’s name and address. Each author is paid a certain royalty rate on each book he or she authors, which potentially varies for each book and for each author. An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and we also keep track of the date and amount of each check. As you develop the ERD for this problem, follow good data naming guidelines.arrow_forwardUse the ER Dlagram shown on Figure 1 to answer question 9: 9. According to the ER diagram on Figure 1, which of the following is true? A) For each employee, we will keep track of either the employee name or the unique employee ID. B) For each department, we will keep track of either the unique department ID or the department location. C) Each employee reports to exactly one department. A department may have many employees reporting to it, but it does not have to have any. D) None of the above. Answer: EmpID EmpName EMPLOYEE Reports To Figure 1 DeptID DEPARTMENT DeptLocationarrow_forwardConsider 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_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 LearningA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrPrinciples 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