I need business rules for these tables for my college project. I have created al

Question

I need business rules for these tables for my college project. I have created all these tables and given them constraints and datatypes. I just need Business rules now
please give me business rules for all the tables in a good way

3. TABLES 1. Theatres 2. Auditoriums 3. Movies 4. Customers 5. Bookings 6. Tickets THEATRES Attribute Constraint Data TypeLength Primary key number Description ThID ThNam ThAddress ThPhone NoOfAuditoriums Number of auditoriums in each theatre Unique id for each theatre Name of theatre Address of theatre Telephone number of theatre Varchar2 Varchar2 number Varchar2 20 40 10 AUDITORIUMS Attribute AulD ThID AuType Constraint Data TypeLength Primary key Number Foreign key number Check (IMAX, Varchar2 5 4D, 3D, 2D) Description Unique id for each auditorium Theatre ID from theatre table Type of auditorium 5 5 RowCount Number of rows in each auditorium SeatCount Number of seats in a row in each auditoriumm number number

Explanation / Answer

Answer is as follows :

According to the given scenario the business rules are defined as follows :

1. One Theatres has one or more Auditoriums but one Auditorium is located to one and only one Theatre.

2. One Auditorium has been showing one or more movies according to the time variation. But on a Particular time there is only one movie in one auditorium.

3. One customer have One or More bookings at different date and time, but a booking has only one Customer.

4. One Movie has multiple bookings but one booking is related to one movie only.

5. One Booking have multiple tickets becasue one customer can book multiple tickets, but one ticket is related to only one booking slot.

6. A movies have multiple tickets but one ticket is related to only one movie.

if there is any query please ask in comments...

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.