1 - Create a "Data Warehouse" for a management system for a cinema chain. The database must store information about films, theaters, tickets sold, customers and cinema sessions. • Films: must have an identifier, title, director, genre and duration. • Rooms: must record the identifier, capacity and location. • Tickets: must record the identifier, the price, the identifier of the customer and the associated cinema session. • Customers: must have an identifier, name, and date of birth. • Sessions: must record the identifier, date and time, the film being shown and the room where it takes place. Define the dimension tables for the "Data Warehouse" and display the fact table.

1 - Create a "Data Warehouse" for a management system for a cinema chain. The database must store information about films, theaters, tickets sold, customers and cinema sessions. • Films: must have an identifier, title, director, genre and duration. • Rooms: must record the identifier, capacity and location. • Tickets: must record the identifier, the price, the identifier of the customer and the associated cinema session. • Customers: must have an identifier, name, and date of birth. • Sessions: must record the identifier, date and time, the film being shown and the room where it takes place. Define the dimension tables for the "Data Warehouse" and display the fact table.

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

When designing a database, a business must take into account the data itself, as well as the ease of access, the database's logical structure, and its physical layout. Explain these topics in further detail.
To create database field requirements, what choices must be made?
When creating a database, here are the general steps that I follow: (a) determine the purpose of the reports I want to generate, (b) identify the format of the report, (c) ensure the data needed is available, (d) confirm the data is reliable. In some cases, the report format that I want to use is not available. Thus, I will work with my tech team to create the report. How can someone determine if the data is reliable? How can it be confirmed? Please discuss.
1 Task 2. Database Create a database with a table with appropriate fields and properties per the scenario. Include records for at least 10 employees with attributes such as Bill Number, Customer Type, and Tariff Rate. Provide screenshot(s) of the process of creating the database including the database server role together with explanations of the steps taken to complete the task.
Case Study Hello Holidays Management System Hello Holidays is a travel company based in Selangor. They specialize in organising day trips to various destinations in Selangor, KL, and Melaka. Customers of Hello Holidays include individuals, institutions such as schools, nursing homes, etc. They hire coaches with drivers for trips that are organized and arranged, especially for them. The manager of Hello Holidays is responsible for the allocation of coaches and drivers for trips. Trip records are created when trips are arranged. If a customer (for whom a trip is being arranged) is new then the customer's details are recorded. Otherwise, the customer's record is updated. Customers will typically request that a day trip be organized for them on a specific date. The number of coaches allocated to a trip depends on the number of seats required. In response to this request, the Hello Holidays manager will check to see if the required coaches can be made available on that date. If the coaches…
We would like to design a database to store information that is related to a charity agency, the database requirements are as follows: • Information kept about each employee: o Employee identification number (unique for each employee), username and password, name for each employee, date of birth, phone, and email. • Information kept for each Donation: o Donation identification number (unique for each donation), donation date, and donation type. • Information kept for each donor: o Donor identification number (unique for each donor), the donor name, the donor name stored separately (first name, second name, and last name), the donor address also stored separately (street number, street name, zip code, city), the phone, and the email. • Information kept about each item donated: o Item identification number (unique for each item), item name, and quantity. • Information kept for each needed/supported family: o Family name, number of members in the family, nationality, address, income, and…
A learning company wants to set up its database. They are trying to keep track of the following: student ID, name, grade level, the subject they need help in, and their contact and payment information. They also want to keep track of the teacher' information such as their ID, name, subject matter expertise, and times available and rate. They will like to keep track of which student is assigned to which teacher and their meeting schedule as well. Question 1: List all of the data that needs to be kept track of for the scenario above in a 1NF (Flat File) table Question 2: Use the normalization technique and form the 3NF tables
When you are developing a database, there are different stages involved. Explain any four of these stages.
When designing a database, a business must take into account the data itself, as well as the ease of access, the database's logical structure, and its physical layout. Explain these topics in further detail.
In order to keep track of a project's progress, create a database transaction. The positive aspects of the purchase should be thoroughly covered.
A learning company wants to set up its database. They are trying to keep track of the following: student ID, name, grade level, the subject they need help in, and their contact and payment information. They also want to keep track of the teacher’ information such as their ID, name, subject matter expertise, and times available and rate. They will like to keep track of which student is assigned to which teacher and their meeting schedule as well. Question 1: List all of the data that needs to be kept track of for the scenario above in a 1NF (Flat File) table Question 2: Use the normalization technique and form the 3NF tables