Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
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.
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…
Chapter 4 Solutions
Modern Database Management (12th Edition)
Ch. 4 - Prob. 4.1RQCh. 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 - For your answers to the following Problems and...Ch. 4 - Transform Figure 2-15a, attribute version, to 3NF...Ch. 4 - Prob. 4.41PAECh. 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
- An 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_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_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
- Specification Suppose you are asked to design a club database system based on the _following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees. Question Draw an E-R diagram for the system according to the above description.arrow_forwardPrepare an Entity Relationship Diagram for the application described in the following paragraph. Pick and Shovel Construction Company is a multi-state building contractor specializing in medium-priced town homes. Assume that Pick and Shovel’s main entities are its customers, employees, projects and equipment. A customer can hire the company for more than one project, and employees sometimes work on more than one project at a time. Equipment, however, is assigned to only one project at a time. Draw an ERD showing those entities.arrow_forwardDatabase Design Before an Essential Oil product is marketed, testing is carried out based on the production batch from any essential oil. This is done to maintain the quality and content of the existing constituents in essential oils. Where the Test Percentage Content must reach the Minimum standard Percentage Content for each constituent. If there is one type of constituent that does not fulfill minimum standard, the batch will not be marketed because it does not meet the standard quality. 1. If recording the results of each testing process is still done manually,according to you please explain which approach fits between Centralized and View Integration for gathering requirements. 2. What Fact Finding Methods you will choose to getinformation related to the development of a database system to record the testing process, and explain the reasons for choosing. 3. Create 1-NF, 2-NF, 3-NF Normalization for the available forms. 4. Make an ERD (Entitiy Relationship Diagram) based on the…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 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