Question: 6. Given a table used by an online ticket box office SHOW_TICKEST PurchaseID, Customer name, ShowName, ShowTime, seatNo. Customer Email, Custmer phone, Number-of-Tickets, Theater Name,

6. Given a table used by an online ticket box office SHOW_TICKEST PurchaseID, Customer name, ShowName, ShowTime, seatNo. Customer Email, Custmer phone, Number-of-Tickets, Theater Name, Theater Address, Theater Phone) When customer make a online purchase for a show with any number of tickets, systems create a PurchaseID, A show is held in certain theater multiple times a day. Some theaters have same shows. A show may be held at several theaters. Each seat has its own seatNo. 6a Based on your analysis to above information, list all functional dependencies 6b What is the KEY of SHOW TICKETS 6c. How many themes this table implies? 6d What normal form this table is in? Why? 6e. How do you normalize it? Show the normalization result

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 5th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, fifth edition, 2006. Prepared by John Kammeyer-Mueller...

intro to basebas 1. (TCO 4) A(n) _____ provides a detailed description of all attributes in the ERD including their datatypes. (Points : 4) entity relationship diagram data dictionary business rule...

1. (TCO 6) To retrieve all fields from a table, use (Points : 3) SELECT ALL. SELECT ANY. SELECT (). SELECT *. Question 2. 2. (TCO 6) Which operator would be most appropriate to determine books with a...

2 Given a table used by a gallery to keep track all transactions customer buy and sell artists works from to the gallery Assuming the given data shows all possible FDs artisti artistName 1 1 2 3 3 3...

Question 6 Given the table from the textbook, Example 5.1, that is shown here, what is the probability of choosing a girl that is either 6 or 7 years old? Give the answer as a decimal to the...

Hello! I need help studying this, and a thorough explanation would be appreciated tysm! Review: 2.9 through 2.12 Show work for credit. No work = no credit. Rewrite the following logarithms as...

5. An SQL data type of ________________ would indicate a variable-length character string with maximum length 75. 6. Given the table STUDENT(StudentID, Name, Advisor) , which of the following SQL...

The sums of the first columns of M for the player data in Table 6 and the first columns of SM for the player data in Table 6 given in Table 7. Find and compare the offensive earned run averages of...

5. Does the following Venn Diagram represent mutually exclusive events? B) False 6. Given the table below. Calculate the mean, variance \& standard deviation. 7. Given the table below. Calculate the...

estion 6 Given this table and the query. yet answered eno tked out of 200 Emp E1 Remove flag E2 E3 E4 ES E6 E7 ES ename title salary J. Doe EE 30000 M. Smith SA 50000 A. Lee ME 40000 J. Miller PR...

Using the linspace command, create a row vector (assign it to a variable named Nines) with nine elements that are all 9.

What are some operations/supply chain management strategies that can be used to deal with the challenges of diminishing natural resources?

ngie was hurt on January, 1 and cannot go back to work. She has a disability policy with a the usual grace period for a disability policy. Approximately when will her grace period end? December, 31...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

4. Sears designed a training program to improve tool and hardware sales. The two-hour program involved distance learning and was broadcast from the Sears training facility to 50 salespersons at 10...

7. A group of managers (N25) participated in the problem-solving module of a leadership development program two weeks ago. The module consisted of two days in which the group focused on the correct...

9. What metrics might be useful for evaluating the effectiveness of a companys training function? Discuss and rate their importance.