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

3. (Part A) Let G = (V,E, R, S) be a CFG that generates a language A. Prove or disprove: The CFG G' = (V, E, RU {S → SS}, S), i.e., adding a new rule S → SS to R, generates the language A*. |(Part B) Give a pushdown automata (draw the state diagram) for the following language over E = {a, b} L = {w| w has more a's than b's}. Solution:
how to build a bookstore database with Entities for Tables Books This entity will store information about the books in the bookstore, such as title, author, publisher, and publication date. The table could also include additional fields such as genre, language, and the number of pages. Authors This entity will store information about the authors of the books in the bookstore, such as name, date of birth, nationality, and biography. The table could also include additional fields such as gender, education, and awards. Bookstore Members This entity will store information about the bookstore members, such as name, address, phone number, email address, and membership status. The table could also include additional fields such as date of birth, occupation, and membership type.
Show the schema for a database that keeps track of courses, students, and the courses they are enrolled in. Note all primary keys. You should have 3 schema.
When constructing a database, an organization has to give careful consideration to the following aspects: the database's content, access, logical structure, and physical organization. Give further detail on each of these things.
Consider the circuit B 1. Derive the Boolean equations representing the outputs D = B = 2. Complete a truth table for the circuit Are both outputs minimized to the fewest number of literals/gates? Use the next page as workspace if needed. 3.
Database Management Systems Prepare your unnormalized term project's first, second, and third normal forms. Then, once more, de-normalize your project's normalised form into unnormalized form. SCHOOL MANAGEMENT SYSTEM is the name of the project.
Subject = database system Please help with the problem in the picture below
Maintaining a database requires constant supervision. What's involved? A database administrator's typical day?
In a library management system, the data management requirements are described as follows:(1) Books are uniquely identified by the Book_id. Users can query the book name, quantity, and its stored location. (2) Before borrowing the book, the library staff will read the borrower information, which includes borrower_id, borrower_name and department. (3) Each book is published by a publisher. A publisher can publish several books. The publisher information includes publisher name, publisher telephone, and publisher address. (4) Each user can borrow several different books, each book can be borrowed by several users. The action of borrow has the attributes of borrowing date and returning date. According to the descriptions above, please finish the following questions: Design the Entity-Relationship diagram. 2. Change the ER model into the relational model. Also identify the primary and foreign key in schemas.
Please describe what is the purpose of the database. Your design proposal should include the elements below: the problem a database is supposed to solve (or the reason for the database) the constraints associated with the database project the objectives you what to accomplish by designing a database the scope of your database design project the boundaries that describe what is and what is not included in your database project.
What are some of the most significant considerations when developing a database for use in the real world?
How does the Database Approach ensure the data's quality?