Create the ERM.FIGURE Q3.22 THE CH03_THEATER DATABASE TABLESDatabase name: Ch03_TheaterTable name: DIRECTORDIR_NUM DIR LNAME DIR DOB100 Broadway101 Hollywoody 18-Nov-53102 Goofy12-Jan-6521-Jun-62Table name: PLAYPLAY CODEPLAY NAME1001 Cat On a Cold, Bare Roof1002 Hold the Mayo, Pass the Bread1003 I Never Promised You Coffee1004 Silly Putty Goes To WashingtonDIR NUM1021011021001005 See No Sound, Hear No Sight1011006 Starstruck in Biloxi1021007 Stranger In Parrot Ice101

The ER model has been designed using crow's foot model below . Since the question does not specify…

Create the ERM. FIGURE Q3.22 THE CH03_THEATER DATABASE TABLES Database name: Ch03_Theater Table name: DIRECTOR DIR_NUM DIR LNAME DIR DOB 12-Jan-65 100 Broadway 101 Hollywoody 18-Nov-53 102 Goofy 21-Jun-62 Table name: PLAY PLAY CODE PLAY NAME 1001 Cat On a Cold, Bare Roof DIR NUM 102 1002 Hold the Mayo, Pass the Bread 101 1003 I Never Pronised You Coffee 102 1004 Sily Putty Goes To Washington 1005 See No Sound, Hear No Sight 100 101 1006 Starstruck in Biloxi 102 1007 Stranger in Parrot ice 101 8E88585

Create the ERM. FIGURE Q3.22 THE CH03_THEATER DATABASE TABLES Database name: Ch03_Theater Table name: DIRECTOR DIR_NUM DIR LNAME DIR DOB 12-Jan-65 100 Broadway 101 Hollywoody 18-Nov-53 102 Goofy 21-Jun-62 Table name: PLAY PLAY CODE PLAY NAME 1001 Cat On a Cold, Bare Roof DIR NUM 102 1002 Hold the Mayo, Pass the Bread 101 1003 I Never Pronised You Coffee 102 1004 Sily Putty Goes To Washington 1005 See No Sound, Hear No Sight 100 101 1006 Starstruck in Biloxi 102 1007 Stranger in Parrot ice 101 8E88585

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

SQL script which is the physical design for this database ### Animals This table contains the following data about all animals in the zoo. - animal ID (primary key) - animal name - animal birthdate - species - habitat (foreign key) [1 habitat to many relationship] ### Habitats This table contains data about the habitats in the zoo. Each animal lives in a specific habitat. The habitat table should include the following data - habitat name, foreign key) - habitat location ### Database CREATE DATABASE zoo; Write queries to create the tables. Be sure to include primary keys for each table and the required foreign keys and referential integrity actions. Add appropriate indexes. This database requires at least 2 indexes in addition to those automatically created by MySQL.
Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT. ANSWER IN MYSQL PLEASE
SQL QUERY!!
Question 2 and 3
SQL Help The Car Maintenance team wants to learn how many times each car is used in every month and day to organize their maintenance schedules. The team wants a table with the following column names and information: Car ID Month Day Count You need to create a summary table using the WITH ROLLUP modifier and grouped by the specific column names, listed above, and send the data back to the team. Query the frequency of each car's use by month and day
Database
Write SQL command to create above table “course” and insert the above values. ccode cname C101 Database concepts and design C102 Software Engineering C103 Human Computer Interaction C104 Programming-2 C105 Multimedia Write SQL command to create above table “student” with REFERENCES and insert the above values. Hints:- In table student ccode is a FOREIGN KEY. sid sname ccode 101 Abdullah Ahmad C101 102 Ali C102 103 Hazmi C104 104 Khalid C102 105 Ali Ahmad C103 Write SQL command to display sname(student name) from student table and corresponding cname(course name) from course table using inner join. Your output should be like this sname cname Abdullah Ahmad Database concepts and design Ali Software Engineering Hazmi Programming-2 Khalid Software Engineering Ali Ahmad Human Computer Interaction (in a program mycmpiler)
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…
Find the names of the pilots who are not certified to fly the aircrafts in the flight table. Sort the name by ascending order.
question 5 use the following picture to answer the following question Assuming all other tables are created, write a statement to create Inventory table with a Composite Primary key (INVID, ITEMID) and two Foreign Keys (INVID and ITEMID).
Topic: Database Software: SQLite Schema Table: CREATE TABLE name_basics (nconst VARCHAR(45) NOT NULL, primaryName VARCHAR(45) NULL, birthYear YEAR(4) NULL, deathYear YEAR(4) NULL, age INT NULL, movieNum INT NULL, PRIMARY KEY (nconst)); CREATE TABLE attributes (attributeID INT NOT NULL,attribute VARCHAR(45) NOT NULL,PRIMARY KEY (attributeID)); CREATE TABLE attributes_collection (akasID INT NOT NULL,attributeID INT NOT NULL,PRIMARY KEY (akasID, attributeID),CONSTRAINT attributeIDFOREIGN KEY (attributeID)REFERENCES attributes (attributeID)ON DELETE NO ACTIONON UPDATE NO ACTION);CREATE TABLE crew_directors (crewID INT NOT NULL,nconst VARCHAR(45) NOT NULL,PRIMARY KEY (crewID, nconst),CONSTRAINT crewIDFOREIGN KEY (crewID)REFERENCES title_crew (crewID)ON DELETE NO ACTIONON UPDATE NO ACTION,CONSTRAINT nconstFOREIGN KEY (nconst)REFERENCES name_basics (nconst)ON DELETE NO ACTIONON UPDATE NO ACTION);CREATE TABLE crew_writers (crewID INT NOT NULL,nconst VARCHAR(45) NOT NULL,PRIMARY KEY…
create a unique Key Index