Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 4, Problem 4.50PAE
Program Plan Intro
a. Show functional dependencies of the flat file given
Program Plan Intro
b. Normal form of table given
Program Plan Intro
c. Normalize the given table into 3NF.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
In derby database and java language
1. You are asked to design a database for Banks. A bank will have one unique Code, Name andAddress. Banks will have multiple branches and each of those branches will be numbered (1,2..), first branch will be Number 1 for example and these will have an address of their own besides thebranch number. The Bank Branches will offer the option of creating accounts to customers, they willalso have the option of creating joint accounts. Customers will be able to open different accounts ineach of the bank branches. Account information will include the unique Account Number, TotalBalance and Account Type. The Bank Branches will also give Loans to Customers. Loans will haveunique Loan Number, Loan Amount and Loan Type. A customer can take multiple loans from acertain bank branch and banks can issue a number of different types of loans just like accounts. Thecustomer’s National_ID, Name, Phone and Address will be taken and stored. Using theseRequirements please construct an Entity-Relationship…
“Martial Arts R Us” (MARU) needs a database. MARU is a martial arts school with hundreds of students. The database must keep track of all the classes that are offered, who is assigned to teach each class, and which students attend each class. Also, it is important to track the progress of each student as they advance.
Students are given a student number when they join the school. The number is stored along with their name, date of birth, and the date they joined the school.
All instructors are also students, but clearly not all students are instructors. In addition to the normal student information, for all instructors, the date that they start working as an instructor must be recorded along with their instructor status (compensated or volunteer).
An instructor may be assigned to teach any number of classes, but each class has one and only one assigned instructor. Some instructors, especially volunteer instructors, may not be assigned to any class.
A class is offered for a…
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
- “Martial Arts R Us” (MARU) needs a database. MARU is a martial arts school with hundreds of students. The database must keep track of all the classes that are offered, who is assigned to teach each class, and which students attend each class. Also, it is important to track the progress of each student as they advance. Students are given a student number when they join the school. The number is stored along with their name, date of birth, and the date they joined the school. All instructors are also students, but clearly not all students are instructors. In addition to the normal student information, for all instructors, the date that they start working as an instructor must be recorded along with their instructor status (compensated or volunteer). An instructor may be assigned to teach any number of classes, but each class has one and only one assigned instructor. Some instructors, especially volunteer instructors, may not be assigned to any class. A class is offered for a…arrow_forwardIn Perl language Inserting data into a flat-file database and amounts to simply tacking the new data onto the end of the file For example, inserting a new megalith record into a colon-delimited file can be expressed ?|arrow_forward1. You want to design a database for a restaurant. Customers have em password. Each customer can have several credit cards registered in the system, each credit card has a 16 digit number, an expiration date, a 3 digit number (CVC code), and the name on the card. The menu items have a short description, a long descriptioin and a price. Customers can place orders that have the date/time that they were placed, one or several menu items (for each menu item it also keeps the quantity), and the total price (summation of the prices of the items mutiplied by the quatity of each item). There are two types of orders: dine-in, or pick-up. In the case of pick-up orders the system must have the car make, model, and color of the person picking up the order, as well as a parking spot number. Dine-in orders have a tip. In addition, the system needs to know if an order has been paid or not. Draw a complete ER diagram. Your diagram must include ISA relationships. If you need to make additional…arrow_forward
- 4. Movie Store System This is a system for selling and buying DVDs and videos of movies. There will be three types of users. First the regular customers, they can access the database of DVDs and videos with different types of search. Second there is a group of users that can post DVDs or/and videos to be sold. These users have access to add movies to the database, so that regular customers can search for these movies. When the customer has finished searching for a DVD and/or a video he/she can communicate a message to the seller in order to buy the product from him. The third class of user is the administrator; this user will be in charge of administrating the database and users. The administrator will be in charge of giving and revoking selling privileges to regular customers so that they are able to add videos and DVDs in the database. Use Visual Paradigm to answer the above question with following four UML diagrams: UML Diagram to be used: USE CASE (For Documentation), Class Diagram…arrow_forwardComputer Science It is needed to design a database system for a pharmacy. The pharmacy contains many different items. Items may be products or medicines. Medicines are classified into different types either bills, injection, capsule or drugs or any combination of them. An item must be supplied by only one supplier. A supplier may supply many type of items. A customer may order many items. The pharmacy has a unique name, address and more than one telephone. The doctor can prescribe one or many medication, injections can not be bought without a doctor prescription. You are requested to draw the EERD diagram for the described system You are required to write down any assumptions made from your side You should add the attributes and cardinality for all the entities You are required to model the EERD into relational modelarrow_forwardIn Python Program: Create a small Family database with one table to include data about members of your family. Include data fields such as first name, last name, type of relationship, hometown, and age. Include one field that uniquely identifies each record, such as a family member number. You can be creative with the family member number or use the auto-generated number from the database. Populate the database with members of your family. Be sure to include data about yourself in the table. Place at least 10 records in your database table, even if it is necessary to make up information. Write a program to display all of the data that appears in the database table on a data grid.arrow_forward
- Software Engineering The recruitment agency TEMPO proposes internship employees for enterprises for a periodof time. An internship employee is a temporary employee that will be recruited for a periodof time. You must develop a database application in order to satisfy these specifications: The enterprises (id, name, address and phone number) define the posts for which theyneed one or many employees. A post is defined with a label, a daily remuneration, thestart date, the end date and the number of employees for this post. A post needseventually diploma(s) and a list of many skills. An internship employee is described by a ssn, first name, last name, an address, aphone number, his/her diplomas (we store for each diploma the year when it isobtained) and his/her skills. An employee could be recruited for one or many posts. This recruitment of anemployee for a given post is validated by a chief (ssn, first name, last name, address)designated by the enterprise. This chief is unique to an…arrow_forwarduse c++ language You run an e-comměrce website and want to record the last N order ids in a log. Implement a data structure to accomplish this, with the following API: record(order_id): adds the order_id to the log get_last(i): gets the ith last element from the log. i is guaranteed to be smaller than or equal to N. You should be as efficient with time and space as possible.arrow_forwardComputer Science Write the code for a book managing system that will record books in a SQLite database in Android Studio using Java. The user need to register on the app by entering name, age, address, reading interest (e.g. fiction/nonfiction). The user will be provided with a user name/email ID, which will be used to maintain the record of each unique user. The app should ask a user to log in with a user name and password. Once the user is logged in, the app should display three options “Add a book, update a Book and Borrow a Book. If a user chooses add a book option, new activity should open asking for book details (title, author, publisher and publication year). If a user chooses update a book option, new activity should open showing a particular book details and should give the option to update the book’s information including status. The book status needs to be updated if the book is borrowed by others. If the user selects Borrow a Book option the app should ask the user to…arrow_forward
- The screen shown is used to enter the sales of the products into the sales and salesdetails tables. It utilizes the four depicted files ProductDAO.java, Product.java, PosDAO.java and Pos.java. The schema for the database is also depicted. The java code utilizes a jconnector to retrieve data from the database. When a product code is entered and then a quantity is entered, on the enter key pressed, the product code is sent to the getProduct(String ID) of a ProductDAO object and that function connects to the database and retrieves the data, placing it into a Product object and return this as Product object so that it can be placed into the Jtable of the PosGUI screen. Write the code for the getProduct(String ID) function located in the ProductDAO file. The code is equivalent to the prodid.arrow_forwardPerlarrow_forwardYou are creating a database for storing information for a Netflix like service. The database stores movies with id, title, filename and TV shows with id, title. TV Shows have episodes. Each episode has a corresponding TV show, a season id, an episode id, title, filename. Some episodes have a next episode (i.e. the episode that will automatically start showing once the user finishes watching the current episode!). The database also stores users, each user has an id, username, password. Users may watch zero or more movies, zero or more TV show episodes. For each movie or episode, the database stores a watch time value for each user, indicating how many minutes the user watched that movie or show. Finally, the database stores which movie appears similar to which other movie for a given user (to be able to make recommendations). Construct an E-R diagram (based on a Chen's model) to represent the above requirements. Make sure you include all appropriate entities, relationships, attributes,…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Systems ArchitectureComputer ScienceISBN:9781305080195Author:Stephen D. BurdPublisher:Cengage Learning
Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning