Modern Database Management
13th Edition
ISBN: 9780134773650
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 solutionStudents have asked these similar questions
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…
In 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 ?|
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…
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
- Computer 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_forwardThe 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_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
- You need to use Java to connect with the mysql and create a simple mysql system. Databases "POS" have 4 tables 1. Staff_Info Staff_ID Staff_Name Staff_Pw Staff_Title 001 AA 1111 Manager 002 BB 2222 General Once the pos system opened, you need to ask the staff to enter the password. The manager can see the payment record if needed, which the general staff cannot. Food_Info Food_ID Food_Cat Food_Name Price 001 burger Classic burger 32 002 burger Chicken burger 38 003 side Fires 10 004 side Salad 15 005 beverage Coke 5 006 beverage Lemon Tea 8 There are only three categories of food, and 6 in total. Order_Info Order_ID Payment_ID Order_Item Order_Quantity Order_ID and Payment_ID should be automatically generated from 0001. Payment_Info Payment_ID Payment_Amount Payment_Date Payment_Time Payment_Method There are two types of…arrow_forwardComputer Science Objective: To create a JSON for Population census with objects and arrays Scenario: def Census Company is maintaining database on the survey taken. Application sends the details of schemes in the form of JSON Help to create a JSON with the information provided. Name Datatype of value Country String State String YearOfSurvey Number TotalPopulation String AgeGroup Object AgeGroup- Object : Name Datatype of value 0-14 Array 15-24 Array 25-44 Array 45-64 Array Above65 Array Array : Name Datatype of value male Number female Number You can assume any data for the mentioned JSON structure, provided it is matching the specified datatypearrow_forward*C programming Write a ccdel program that takes an item number as a command line argument and deletes that item from the database. All other items should remain in their current positions with their current item numbers. Include proper file locking.arrow_forward
- Programming Language BSL Purpose To design a small program using structured data. Expectations You should submit a single .rkt file containing your responses to all exercises via the Handin Server. We accept NO email submissions. Failure to submit a .rkt file will result in a 0. You are only allowed to use the language specified at the top of this page: failure to do so will result in a 0. You should only use the concepts that we have covered in class so far. Your code MUST conform to the guidelines outlined in the style guide on the course website. The style guide will be updated as the semester progresses so please remember to read it before submitting each assignment. You must follow all the steps of the design recipe when completing this assignment. Graded Exercises Exercise 1 Design a data definition for a mathematical expression. Your data definition should be able to handle the addition, subtraction, and multiplication of any two integers. You do not need to…arrow_forwardObjective: To create a JSON for Population census with objects and arrays Scenario: DEF Census Company is maintaining database on the survey taken. Application sends the details of schemes in the form of JSON Help to create a JSON with the information provided. Name Datatype of value Country String State String YearOfSurvey Number TotalPopulation String AgeGroup Object AgeGroup- Object : Name Datatype of value 0-14 Array 15-24 Array 25-44 Array 45-64 Array Above65 Array Array : Name Datatype of value male Number female Number You can assume any data for the mentioned JSON structure, provided it is matching the specified datatypearrow_forward1. Develop a data manipulation application with a user-friendly JavaFX GUI for student's database (as shown in the ER diagram below). The user should be able to edit existing data and add new data to the database (obeying referential and entity integrity constraints). Allow the user to edit the database in the following ways: a) Add a new student. b) Edit the existing information for a student. c) Delete an existing student. d) Add a new course registration for a student. Student Registration Course id 1 studentid id name courseid major grade name semester room 2. Upgrade the application in Ql to provide an appropriate JavaFX to allow the user to perfom a query that is defined in a TextArea and the results will be shown in a Tableview. Sample predefined queries are: a) Select all students studying "Software Engineering" major. b) Select students who have excellent grades. c) Select all pass students in ascending order based on their names. d) For all students studying "Computer…arrow_forward
- Follow these steps: Create a program that can be used by a bookstore clerk. The program should allow the clerk to: o enter new books into the database o update book information o delete books from the database o search the database to find a specific book. Create a database called ebookstore and a table called books. The table should have the following structure: id 3001 3002 3003 3004 3005 Title A Tale of Two Cities Philosopher's Stone Harry Potter and J.K. Rowling the The Lion, the Witch and the Wardrobe The Lord of the Rings Alice in Wonderland Author 1. Enter book 2. Update book 3. Delete book Charles Dickens 4. Search books e. Exit C.S. Lewis J.R.R Tolkien Lewis Carroll Qty 30 40 25 37 Populate the table with the above values. You can also add your own values if you wish. The program should present the user with the following menu: 12 The program should perform the function that the user selects. The implementation of these functions is left up to you.arrow_forwardSCENARIO:A database contains information about ticket reservations for movie performances. To make a reservation you must be registered as a user of the system. In order to register you choose a unique username and enter your name, address, and telephone number (the address is optional). When you use the system later, you just have to enter your username. In the system, a number of theaters show movies. Each theater has a name and a number of (unnumbered) seats. A movie is described by its name only. (In a real system you would, of course, store more information, such as actor biographies, poster images, video clips, etc.) A movie may be shown several times, but then during different days. This means that each movie is shown at most once on any day. You can only reserve one ticket at a time to a performance (if you want several tickets for the same performance you must make several separate reservations) and cannot reserve more tickets than are available at a performance. When you make…arrow_forwardC++ Write a program that will allow a user to enter students into a database. The student information should include full name, student ID, GPA and status. The program should allow delete any student based on student ID.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Systems ArchitectureComputer ScienceISBN:9781305080195Author:Stephen D. BurdPublisher:Cengage LearningProgramming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:CengageFundamentals 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