Identify the primary keys.FIGURE Q3.22 THE CH03_THEATER DATABASE TABLESDatabase name: Ch03_TheaterTable name: DIRECTORDIR_NUM DIR LNAME DIR DOB100 Broadway12-Jan-65101 Hollywoody 18-Nov-5321-Jun-62102 GoofyTable 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 Washington1005 See No Sound, Hear No SightDIR NUM1021011021001011006 Starstruck in Biloxi1021007 Stranger In Parrot Ice1018588585

given are the two table: to determine: we need to find primary keys

Database name: Ch03_Theater Table name: DIRECTOR DR _NUM DR LNAME DIR DOB 100 Broadway 101 Hollywoody 18-Nov-53 102 Goofy 12-Jan-65 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 Promised You Coffee 102 1004 Sily Putty Goes To Washington 100 1005 See No Sound, Hear No Sight 101 1006 Starstruck in Biloxi 102 1007 Stranger in Parrot ice 101

Database name: Ch03_Theater Table name: DIRECTOR DR _NUM DR LNAME DIR DOB 100 Broadway 101 Hollywoody 18-Nov-53 102 Goofy 12-Jan-65 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 Promised You Coffee 102 1004 Sily Putty Goes To Washington 100 1005 See No Sound, Hear No Sight 101 1006 Starstruck in Biloxi 102 1007 Stranger in Parrot ice 101

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

question 6 use the picture below to answer the following question Add a ZIP field/column to the customer table.
Write Create Table SQL statements Work Session table The table must have a primary key. The table must have appropriate foreign key constraints. Foreign keys must have the same name, datatype and size of the primary key that they refer to The following columns datatypes and sizes and named constraints must be used Column DataType Constraint WorkYear number(4) Range 2019 - 2020 WorkWeek number(2) Range 1-52 WorkHours number(4,2) Range 0.5 – 99.99 BID NUMBER(4) ,AUTHID NUMBER(4)
write php codes for an expense track weballow to add income, expense record, and expense summarysave to mysql databaserepresent data in chartjavacripts to validate forms, input fields login and registration php forms
Apply the First Normal Form (1NF) and Second Normal Form (2NF) steps to the following two tables. ST_ID ST_Name ST_Major St_Phone ST_Email 100 Marla jen ACCT (703) 111-2222 mjen@gmail.com 110 Jan Bok MGMT (703) 222-3333 jbok@verizon.net 115 Lee Chan MIS (703) 333-4444 (703) 444-5555 lchan@cox.net Table 1 ID Name Courses 1 Ashely Key MIS 302, MIS 303 2 Katy Pery MIS 310 3 Mickey Zen MIS 303, MIS 350 Table 2
SQL is software manipulating for managing and the database Select one: True O False
Check the entities to be in the 3NF normal form
sql code sql code sql code
- Delete the employee who has the longest employment in the company
MySQL CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...6. Find the last name of all employees that were not hired on Tuesday *hint: (UseDATE_FORMAT() function amd the format you need is %W, also use UPPER()7. Find the number of employees in each department who have a manager.8. Find the number of employees for each manager whose employees' minimum salary is greaterthan 5000.9. Find the number of…
Database sql 1-Write the syntax to create an object table called people using people_type
Show students’ first name, last name, their phone(s), and phone type
Instructorld 1 • Courseld CourseCode 9630 MATH109 Course CourseName Linear Algebra Capacity 175 4964 PHILAT Intro to Philosophy 50 4253 MATH19 Number Theory 150 1896 HIST66 American History 25 8048 HIST58 World History 125 2133 Instructor Instructorld InstructorName Rank Department Del Day Associate Professor Math Rob Ruiz Associate Professor Philosophy Aya Diaz Associate Professor History Note: Both tables may not be necessary to complete this level. Select the rows returned by the query below. SELECT CourseName, Capacity, InstructorId FROM Course C WHERE Capacity > (SELECT AVG (Capacity) FROM Course WHERE InstructorId = c.InstructorId); CourseName Linear Algebra Capacity Instructorld 175 1 Intro to Philosophy 50 2 150 Number Theory American History 25 World History 125 2133