Hi please help me with this database question thankyou so much The manager of a company dinner club would like to have an information system thatassists him to plan the meals and to keep track of who attends the dinners, and so on.Because the manager is not an IS expert, the following table is used to store theinformation. As a member can attend many dinners and a member will not attend morethan 1 dinner on the same date, the primary key of the following table is Member Num+ Dinner Num. Dinners can have many courses, from one-course dinner to as many3)courses as the chef desired.MEMBER MEMBERNUMDINNERNUMVENUE VENUEFOOD FOODDESCRIPTION CODE DESCRIPTIONMEMBERDINNERDATENAMEADDRESSCODE325Grand Ball214Peter WongMeadowDO00115-Mar-10B01EN3Stu ed crabRoomParkChocolateDE8mousse123 Rose235Mary LeeDO00215-Mar-10B02Petit Ball Room EN5Marinated steakCourtChocolateDE8mousse250Peter Wong9 Nine AveDO00320-Mar-10Co1Caféso1Pumpkin soupENSMarinated steakDE2Apple pie123 Rose235Mary LeeDO00320-Mar-10Co1CaféSoiPumpkin soupCourtENSMarinated steakDE2Apple pie123 Rose300Paul LeeDO00420-Mar-10E10Petit Ball RoomSA2Apple pieCourtFigure 3: Sample Data for the Dinner Club's Member table(a) The table shown in Figure 3 is susceptible to update anomalies. Briefly explain andprovide examples of insertion, deletion, and modification anomalies.(b) Describe and illustrate (by using dependency diagram) the process of normalizing thetable shown in Figure 3 to 3NF.

Answered: Image /qna-images/answer/7e94a424-4a2d-44d0-8c16-d57b58ce05b0.jpg

Answered: Hi please help me with this database…

Engineering

Computer Science

Hi please help me with this database question thankyou so much

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Consider the following database instance. Table name: Students Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen Table name: Courses Primary key: cid cid cname 1 ICS 2 Finance Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1 5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’); INSERT INTO Students VALUES (6, ‘Ellen’); INSERT INTO Register VALUES (1, 2); INSERT INTO Courses VALUES (5, ‘Systems’); INSERT INTO Register VALUES (6, 5); INSERT INTO Register…
Suppose we want to develop a browser-based training system to help people prepare for such a certification exam. A user can request a quiz for the system. The system picks a set of questions from its database, and compose them together to make a quiz. It rates the user’s answers, and gives hints if the user requests it. In addition to users, we also have tutors who provide questions and hints. And also examinators who must certify questions. List down the functional requirements of the above said system? Use Form based method for specifying “Make Quiz” functional requirement
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…
ID At_fault_claims 1001 0 1001 1 1002 0 1002 1 1002 1 1003 0 1004 1 1005 1 1005 0 Aggregate the the dataframe above at the ID to create the following claim count variables: : Number of At Fault claims Number of Not At Fault claims it should be written with python We should now have two additional columns 'at fault count' and 'not at fault count' in our aggregate dataframe
What are thescenarios where deadlock can occur specify each?
Given the business rule "An employee may have many degrees." Suppose that an employee has the following degrees. BA, BS, MBA, etc. These degrees could be stored in a single string as a multivalued attribute name EMP_DEGREE in an EMPLOYEE table such as the one shown below: EMP_NUM EMP_LNAME EMP_DEGREE 123 Carter BA, BS, MBA 124 Smith BBA, MBA 125 Jones AS 126 Doe BS, MS, PhD. This design is flawed, so correct it by creating additional table(s) and attributes(s) and show the relationships between them. Show all the data above in your table(s). Add additional data if new attributes were added. Show primary and foreign keys in your table(s).
A database has four transactions. Let min sup = 60% and min conf = 80%.cust ID TID items bought (in the form of brand-item category)01 T100 {King’s-Crab, Sunset-Milk, Dairyland-Cheese, Best-Bread}02 T200 {Best-Cheese, Dairyland-Milk, Goldenfarm-Apple, Tasty-Pie, Wonder-Bread}01 T300 {Westcoast-Apple, Dairyland-Milk, Wonder-Bread, Tasty-Pie}03 T400 {Wonder-Bread, Sunset-Milk, Dairyland-Cheese}(a) At the granularity of item category (e.g., itemi could be “Milk”), for the ruletemplate,∀X ∈ transaction, buys(X,item1) ∧ buys(X,item2) ⇒ buys(X,item3) [s,c],list the frequent k-itemset for the largest k, and all the strong association rules(with their support s and confidence c) containing the frequent k-itemset for thelargest k.(b) At the granularity of brand-item category (e.g., itemi could be “Sunset-Milk”),for the rule template,∀X ∈ customer, buys(X,item1) ∧ buys(X,item2) ⇒ buys(X,item3),list the frequent k-itemset for the largest k (but do not print any rules).
Please answer with reason for all why the option is correct and why the other options are incorrectPlease answer correct otherwise skip it A calculated field in the normalisation process requires special treatment. Which of the following is correct? If the borrowing duration is fixed in a library, either of the date-borrowed or the due-date can be kept but not both. If both DOB (Date of Birth) and Age information are available, we will keep the Age information as it is more useful. We can keep either the Starting Time or the Ending Time of a match in a data table regardless of whether the match has a fixed duration or not. None of the other answers are correct.
Consider an employee database with two relationsemployee (employee_name, street, city)works (employee_name, company_name, salary) where the primary keys are underlined. Write a function avg_salary that takes a company name as an argument and finds the average salary of employees at thatcompany. Then, write an SQL statement, using that function, to find companieswhose employees earn a higher salary, on average, than the average salary at“First Bank”.
Open your text editor and create a new document named model.php model.php will connect to a database potentially return PDO statement objects to the controller for processing. This question is complete and requires use of initMessagesfunction initMessages($tim) This method will take a single parameter of unix time using the method “time()”. It will conditionally select fromthe table “messages” the minimum id and rename it to “min_id”. The condition is that the field time is greater thanthe parameter for time. The return is the PDOStatement object with the row data from a query.
Which of the following is NOT an option when implementing referential integrity cascade options? Group of answer choices cascade set to null restrict force
Let's pretend that a piece of a primary key is also a potential secondary key. Your reaction to this?