Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 4, Problem 4.55PAE
Program Plan Intro
a. Functional dependency between given attributes
Program Plan Intro
b. Reason for which thegiven relation is not in 3NF.
Program Plan Intro
c. Convert relation into 3NF
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Draw an ER diagram that captures
the following information: A book
identified by (unique Id number, a
title and one or more authors), A
library identified by (unique name
and adders), A borrower has a name
and a unique ID code. The library
service may own several copies of a
given book. A borrower can have
many books on loan, but each copy
of a book can only be on loan to one
borrower. A borrower could borrow
the same book on several occasions,
but it is assumed that each such loan
will take place on a different date. *
An E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles.
Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.
Each department runs a number of courses. The university provides a set of modules used in different courses. Each course uses a number of modules but not every module is used. A course is assigned a unique course code and a module is identified by a unique module code. A module can be used in one course only, but can be studied by many students. In addition to the module code each module unique title, start date, end date, texts (books), and assessment scheme (i.e., coursework and exam marks percentages) are also stored.
Each course is managed by a member of academic staff, and each module is coordinated by a member of academic staff also. The database should also store each course unique title, and duration (in years).
A student can enroll in one course at a time. Once enrolled a student is assigned a unique matriculation number. To complete a course, each student must undertake and pass all the required modules in his/her course. This requires that the database store the…
Chapter 4 Solutions
Modern Database Management
Ch. 4 - Define each of the following terms: determinant...Ch. 4 - Prob. 4.2RQCh. 4 - Prob. 4.3RQCh. 4 - Describe the primary differences between the...Ch. 4 - Summarize six important properties of relations.Ch. 4 - Describe two properties that each candidate key...Ch. 4 - Describe the three types of anomalies that can...Ch. 4 - Demonstrate each of the anomaly types with an...Ch. 4 - Fill in the blanks in each of the following...Ch. 4 - What is a well-structured relation? Why are...
Ch. 4 - Prob. 4.11RQCh. 4 - Describe how the following components of an E-R...Ch. 4 - Prob. 4.13RQCh. 4 - Prob. 4.14RQCh. 4 - Briefly describe four typical problems that often...Ch. 4 - Prob. 4.16RQCh. 4 - Explain how each of the following types of...Ch. 4 - Prob. 4.18RQCh. 4 - Prob. 4.19RQCh. 4 - Prob. 4.20RQCh. 4 - Prob. 4.21RQCh. 4 - What is the relationship between the primary key...Ch. 4 - Prob. 4.23RQCh. 4 - Explain what can be done with primary keys to...Ch. 4 - Prob. 4.25RQCh. 4 - Explain three conditions that suggest a surrogate...Ch. 4 - Prob. 4.27RQCh. 4 - For each of the following E-R diagrams from...Ch. 4 - Prob. 4.29PAECh. 4 - Prob. 4.30PAECh. 4 - For your answers to the following Problems and...Ch. 4 - Figure 4-3212 shows a class list for Millennium...Ch. 4 - Prob. 4.33PAECh. 4 - Prob. 4.34PAECh. 4 - Prob. 4.35PAECh. 4 - Prob. 4.36PAECh. 4 - Prob. 4.37PAECh. 4 - Prob. 4.38PAECh. 4 - Prob. 4.39PAECh. 4 - Transform Figure 2-15a, attribute version, to 3NF...Ch. 4 - The Public Safety office at Millennium College...Ch. 4 - Prob. 4.42PAECh. 4 - Prob. 4.43PAECh. 4 - Prob. 4.44PAECh. 4 - For your answers to Problem and Exercise 3-33 from...Ch. 4 - Prob. 4.46PAECh. 4 - Prob. 4.47PAECh. 4 - Figure 4-38 includes an EER diagram for a...Ch. 4 - Prob. 4.49PAECh. 4 - Prob. 4.50PAECh. 4 - Prob. 4.51PAECh. 4 - Prob. 4.52PAECh. 4 - Figure 4-40 shows an EER diagram for a university...Ch. 4 - Explore the data included in Table 4-9. Assume...Ch. 4 - Prob. 4.55PAECh. 4 - Prob. 4.56PAECh. 4 - Prob. 4.57PAECh. 4 - Prob. 4.58PAE
Knowledge Booster
Similar questions
- The following attributes fom1 a relation that includes information about individua l computers, their vendors, software packages running on the computers, computer users, and user authorizations. Users are authorized to use a specific software package on a specific computer d uring a specific time frame (characterized with attributes UserAuthorization Starts and UserAuthoriza tionEnds and secured with UserAuthorizationPassword}. Software is licensed to be used on specific computers (potentially multip le software packages at the san1e time) until an expira tion time (SoftwarelicensePrice) a t a specific price. Computers are sold by vendors, and each vendor has a support person with an ID, nan1e, and phone extension. Each individual computer has a specific purchase price. The attributes are as follows: Based on this information, a. Identify the functional dependencies between the attributes. b. Identify the reasons why this relation is not in 3NF. c. Present the a ttributes organized so…arrow_forwardAn Entity Relationship (ER) Diagram is a type of flowchart that illustrates how “entities” such as people, objects or concepts relate to each other within a system. Consider the following description of a system: A university registrar’s office maintains data about following entities: Courses, including number, title, credits, syllabus, and prerequisites. Course offerings, including course number, year, semester, section number, instructor, timings and classroom. Students, including student-id, name, and program. Instructors, including identification number, name, department, and title. Furthermore, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled. Construct an ER Diagram for the registrar’s office. Document all assumptions that you make about the mapping constraints.arrow_forwardSchool system scenario Students come at the beginning of the school year to register in a school system and pay for the year’s fees..Each student is added to the appropriate class . each class has several teachers already registered in the system, tests are made by the teachers and the teacher adds the students' grades in the system, and at the end of the year the system issues students ’certificates. draw Entity Relationship diagram(ERD) from above scenarioarrow_forward
- Q2: Draw an ERD from the following business rules: Use proper notations for the type of attributes A software system is to be developed for an educational institute.The software is intended to be used by faculty members, students and designated support staff. System administrator will also use system for system administration and management. Student’sdata including names, registration number, cell numbers and address will be added and edited by Clerk. The data will be added at the timeof student reporting at campus. Student can enroll into any course of their choice from the offered courses. They can also request for dropping a course. Approval of course dropping of a student will be granted or refused by academic coordinatorsarrow_forwardEach publisher has a unique name; a mailing address and telephone number are also kept on eachpublisher. A publisher publishes one or more books; a book is published by exactly one publisher. Abook is identified by its ISBN, and other attributes are title, price, and number of pages. Each book iswritten by one or more authors; an author writes one or more books, potentially for differentpublishers. Each author is uniquely described by an author ID, and we know each author's name andaddress. Each author is paid a certain royalty rate on each book he or she authors, which potentiallyvaries for each book and for each author. An author receives a separate royalty check for each book heor she writes. Each check is identified by its check number, and we also keep track of the date andamount of each check.TasksDesign a SQL database using the above US superstore sales data set.1.Use Visual Paradigm to draw conceptual diagram2.Use Visual Paradigm todraw ERDarrow_forwardLuxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all of the various information needs of the company. The company's operations are as follows: LOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an employee ID, but the system should also record a guide's name, home address, and date of hire. Guides take a test to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified guides. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides. Every tour must be designed to visit at least…arrow_forward
- Design: An (ER) and (relational Diagram) by showing as I am an owner of a car rental company website describing the following domain: I am the owner of the website, and I see the registered customers records I have through different car types and car rental Every rental operation has a start or end by day or KM Every car has a different price depending on its year production and model We have three rental types( Per Kilometers, monthly, daily) in different prices even though it was the same car Any one can enter his 'id' which includes ( Name, age, gender, address, city, Civil id), and this 'id' is the primary ket to all entities He would proceed to register for renting a car per his choice Then he will send the registrations form that I will analyze and contact him Every customer can rent only one car This choice has one car rental type based on the available listed cars in the registration The owner of that website has the "id" records and the registration database running its…arrow_forwardDATABASE MANAGEMENT Design an EER diagram for a database used to manage a racket sport association (for example, US Tennis Association). The following is a list of simplified requirements. Each member of the sport association has an id, a name, sex, age, an address, a phone number. A member can be a player, an umpire (i.e., referee), a coach, or an officer (i.e. a member can belong to one or more of the above categories). An umpire has a type (i.e., national, international, etc.). A coach has a certificate (i.e., level I, II, etc.). An officer has an office (i.e., a room number such as 101 or 212 in the main building). Each club has a name, an address, an owner, and a phone number. Except for some officers, every member belongs to one or more clubs (Hint: Make relationships between the subclasses of “member” and club). A player can be a professional or an amateur (but not both). A professional player has a rank (such as 1, 2, etc. within the association), and a coach (Note: Every…arrow_forwardwrite the schema that descibes the following relations: 1- The course relation course id title dept.name credits Intro. to Biology Biology Biology Biology Comp. Sci. Comp. Sci. Comp. Sci. Comp. Sci. Comp. Sci. Elec. Eng. BIO-101 4 BIO-301 BIO-399 CS-101 CS-190 CS-315 CS-319 Genetics 4 Computational Biology Intro. to Computer Science Game Design Robotics 3. 4. 4 Image Processing Database System Concepts Intro. to Digital Systems Investment Banking World History Music Video Production CS-347 ЕЕ-181 FIN-201 3 3 Finance HIS-351 MU-199 PHY-101 History Music Physical Principles Physics 4arrow_forward
- Instructions: Read the following Case Study and create a context diagram . When a patient arrives at ACME Medical with a prescription refill, the receptionist checks the prescription file for the previous prescription number and adds the prescription to the system. This has to be electronically authorized by a doctor before the resident pharmacist can dispense the medication. The system sends a cell phone notification to the doctor of any incoming prescriptions. The pharmacist dispenses the medication to the patient after receiving authorization. If the patient is entitled to free prescriptions, the pharmacist verifies this in the system and fills in the appropriate details on an electronic form, which is filed in the free prescriptions file. Otherwise the pharmacist takes the customers payment information, enters it into the system and gives the patient a receipt.arrow_forward1. The table shows a class list for the XYZ UNIVERSITY, convert this user view to a set of 3NF relations. Assume the following: a. An instructor has a unique code. b. Astudent has a unique course. C. A course has a unique description. XYZ UNIVERSITY First Semester, SY 2020-2021 Course No. : COE 412 Description : Operating Systems Instructor Code : 0001 Instructor Name : Mr. X ID NUMBER STUDENT NAME COURSE 38214 BRIGHT BSCPE 40875 CORTEZ BSECE 51893 EDWARD BSITarrow_forwardDraw the associations that are described by the following business rules. Include the multiplicities for each relationship. (4 marks) A patient must be assigned to only one doctor, and a doctor can have one or many patient: An employee has one phone extension, and a unique phone extension is assigned to an employee. A bookstore sells at least one book, and a book can be sold at up to 10 other bookstores around town.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
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
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