Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 4.56PAE
Program Plan Intro
a. Identify functional dependency between the attributes of given relation
Program Plan Intro
b. Identify Normal form of given relation
Program Plan Intro
c. Normalize the relation to 3NF
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time.
The Motor Vehicle Department Database
The Motor Vehicle Branch administers driving tests and issues driver's licenses.
Any person who wants a driver's license must take a learner's exam at any Motor
Vehicle Branch in the province.
If he/she fails the exam, he can take the exam again any time after a week of the
failed exam date, at any branch.
If he passes the exam, he is issued a license (type = learner's) with a unique
license number.
A learner's license may contain a single restriction on it. The person may take
his driver's exam at any branch any time before the learner's license expiry
date (which is usually set at six months after the license issue date).
If he passes the exam, the branch issues him a driver's license.
A driver's license must also record if the driver has completed driver's education, for
insurance purposes.
Requirement Design an entity relationship diagram
for the motor vehicle department database and
build the design using a data modeling tool such as
Visio.
SQL DML/DDL There are five tables describing employees of a company, departments, buildings, which department(s) an employee works in (and a percentage of the time for each), and in which building an employee works (an employee may have more than one office). The primary key of each table is the attribute(s) in capitals and underlined. The foreign keys are in italics. Other attributes are not necessarily unique.Employee (EID, Ename, Salary, Start_Date, End_Date)Building (BID, Bname, Address)Department (DID, Dname, Annual_Budget)In_Department (EID, DID, Percentage_Time)In_Building (EID, BID)Write the SQL statements for the following.1. Find the names of Departments where NO employees work. 2. For employees who are still working in the company, end date has no value (empty). For those who have left the company and have end date values, show their names and the duration of their employment in years. 3. Find the names of buildings where more than 50 employees work. 4. The tables have…
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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- A Bank has many customers. Attribute for customer includes customer number, name, address (street, city, state and zip code), sex and date of birth. Customer can have multiple accounts. The bank does not allow join account (one account per customer). Type of account offer by the bank are Saving, Current and Fixed Deposit. Attribute for account are account no, account type, and account balance. Each of the account can only exist in a particular branch. Attribute for branch are branch no, branch name and address (street, city, state and zip code). Customer can open different account at different branch. Draw an ER diagram for the above situation. Identify the entity, attributes, primary key, relationship and multiplicity constraint in the ER diagram.arrow_forwardAfter sending your resume to an employer, he/she asked you for references. For each and every reference, you have to give the following information: Select one : a. name, place of work, and phone number b name , phone number , and email c , name , address , and email d . name , phone number , and addressarrow_forwardTrue or False When working with the data in a database table, the column that is designated as the primary key must hold a unique value for each row.arrow_forward
- Skiing Database You are a member of New England Ski Club. The Manager of the Ski Club has asked you to design a database to keep track of member and skiing resort information. For each member of the club, the manager will need their name, address, phone number, skiing ability data. For the various ski resorts, you will need to track the name of the resort, # of trails, # of lifts. Also needed is a monthly report of skier activity including the skier's name, phone number, skiing ability, Ski resort visited, the date of the visit and general comments on the skiing there. Create the DBDL for the database using word. Do not over think this case. Do not make any assumptions. You must use the following table names: (Member, Resort, Activity and Ability.) Language: SQLarrow_forwardYour university runs many hundreds of courses each semester and needs to keep track of key information on each one. Among the data needed for each course would be the following: - University course identification number - Department course ID and section number (for multiple sections of the same course) - Number of credits for the course Days and times the course meets - Room in which the course meets (building ID and room number) Maximum course enrollment Campus on which the course is held - Name of the course instructor - Number of students currently enrolled and the student ID of each such student - Course status: open (for additional enrollment), closed, or canceled You must be able to change the value of each of these ten data items and, upon request, display all of this information. Initially, the values of the first seven items are known–the last three aren't. Design and implement an abstract data type that can be used to model this university course entity.arrow_forwardTASK: Examples of the UNION operator, the use the DISTINCT operator. TOPIC : DATABASEarrow_forward
- SQL Helparrow_forwardDatabase introduction based questionarrow_forwardWorkers: Name Worker ID Department Job Title Basic Salary Age Date of Birth Passport Details The system should store details of each worker including their personal information, job-related details, and passport information for identification purposes. Parties: Party ID Type Theme Date Time Duration Venue Address Client ID Guest List Catering Company Cleaning Company Decorations Company Entertainment Company Furniture Supply Company Invoice Each party should have a unique identifier along with details such as type, theme, date, time, and duration. It should also track the venue address, client details, guest list, and the various suppliers involved in organizing the party. Additionally, invoices generated for the party should be recorded. Clients: Client ID Name Address Contact Details Budget Client details including their name, address, contact information, and allocated budget should be stored for each party. Guests: Guest ID Name Address Contact Details The system…arrow_forward
- Fields in a database are defined by their field name, which specifies whether the field contains text, dates, numbers, or other formats. O True O Falsearrow_forwardIn Senior Project Website, the user requests the website to search for previous senior projects, the website displays the search web form, the user inputs the keywords to be used for the search process, the user submits the search criteria to the website, and the website requests a remote database to search for senior projects that fulfill the requested criteria (keywords). The remote database returns back a Boolean value (indicating if the search is successful or not) and a list of found senior projects (the list is empty if not successful), If the search is successful, the website displays the list of received senior projects, else, the website displays error dialog box indicating that no projects were found. Q2. For Senior Project Website System described above, students are required to conduct the following task: a) Design the Sequence Diagram of Senior Project Website System described above.arrow_forwardDATABASE SYSTEMS: QUESTION Do as directed This describes the business process to publish an academic paper. The author submits a paper to an editor in chief of a journal. The editor first checks whether the paper fit the theme of the journal. If not, the editor rejects the paper. Otherwise, the editor in chief assigns the paper to a number of reviewers. The reviewers review the paper, and write a review. The review is sent to the editor in chief. The editor in chief then assesses the quality of the paper with the help of reviewers’ comments. If the quality is good, the paper will be accepted, and the author notified. Furthermore, the paper is forwarded to the publisher for publication. If the quality is bad, the editor rejects the paper. Apply query to only access to compile the final decision to editor in chief and only visualized by author not reviewersarrow_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 LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning