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
Q: Worksheet Query Builder CREATE TABLE TOYS ( ToyID NUMBER (10,0) PRIMARY KEY, Name VARCHAR2 (30),…
A: Answer: I have written code in SQL and this code is working fine
Q: Find the nationalities of all users (remove duplicates).
A: As per our company guidelines, we are supposed to answer only one question per question and kindly…
Q: Database course: Which of the following queries is used to list a unique value for V_CODE, where…
A: District keyword is used to fetch distinct records.
Q: Assume you have a table in your database called World' with the following schema: Table: World |…
A: NOTE: I have given the answer as asked in the question Solution: WHERE: conditionally…
Q: this is a review question! please keep answer simple The SQL statements that answer these…
A: SQL is Structured Query Language, which is a computer language for storing, manipulating and…
Q: ☐ 2NF No Transitive Partial dependency NEW TABLES: ADVISOR STUDENT STU_NUM MAJOR DEPARTMENT ADVISOR…
A:
Q: Create the following table in your database with the following schema: Table: Sales | Column Name |…
A: Create a table Sales: CREATE TABLE Sales ( sale_id int, product_name varchar(255),…
Q: lter table product so that column productlype is an integer instead of a varchar, not null should be…
A: Lets see the solution.
Q: Create the following table in your database with the following schema: Table: SalesPerson | Column…
A: The script is written in SQL. Please check the source code and output in the following steps.
Q: Table: Author Author_ID Author_Name DZN9010 J.K. Rowling VC8931 Arthur Conan Doyle STA7686 Suzanne…
A: Introduction: A transitive dependency in a database is a functional dependency where some non-prime…
Q: Courseld CourseCode CourseName Capacity Instructorld 7994 CS168 125 HIST64 175 8914 5024 8367 8901…
A: Given Tabel1:- Course Table Table2:- Instructor SELECT CourseNameFROM CourseWHERE…
Q: Course: Database *(SQL)* Please excute the given SQL script…
A: 1. Retrieve the flight number, departure and arrival airports of all British Airways. Query: SELECT…
Q: CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY…
A: Actually, SQL is a Structured Query Language.
Q: Create the ERM. FIGURE Q3.22 THE CH03_THEATER DATABASE TABLES Database name: Ch03_Theater Table…
A: The ER model has been designed using crow's foot model below . Since the question does not specify…
Q: hoose 1 string function and 1 numeric function and write a query that uses the two functions you…
A: The given problem is related to MYSQL querie where the logical model of the tables is given and the…
Q: THIS IS A REVIEW QUESTION The SQL statements that answer these questions. please keep the answer…
A: SQL is Structured Query Language, which is a computer language for storing, manipulating and…
Q: 1. Create a database. Name the database yourNameDatabase. 2. Create two tables. Name the tables,…
A: As per our Guidelines I can only answer 3 subpart. Please repost the remaining question
Q: Please excute the given SQL script…
A: Note: as per company guidelines we are supposed to answer only first 3-sub parts at a time. please…
Q: Using php, html and My sql
A: Introduction Php in terms it means Hypertext Preprocessor which is basically been used for to create…
Q: CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY…
A: The record table is inserted with values . The table looks like: The TRACKS table is inserted with…
Q: Create the database and table in MYSQL, PhpMyAdmin as shown below in the screenshot: Database Name:…
A: I have provided answer in step2.
Q: BNew Database Open Database Write Changes Revert Changes Open Project Save Project Attach Database X…
A: We need to write a sql query that display the student name, course number, credits, and grades by…
Q: CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY…
A: Actually, SQL is a language to operate databases in searching and filtering the data according to…
Q: PS5: Webscraping Suggested Solutions Import BeautifulSoup, json, requesrts, and pandas. [ ]: from…
A: SUMMARY: -Hence, we discussed all the points.
Q: Hello, I need help selecting 3 sql tables. These are the instruction. The database has three tables…
A: Tо write аn SQL stаtement tо disрlаy Student Nаme, Student ID, Аddress аnd Рhоne…
Q: FIGURE Q3.18 The Ch03_Theater Database Tables Table name: DIRECTOR DIR_NUM DIR LNAME DIR DOB 100…
A: We solve the answer : Answer 5) we make simple ERD :
Q: Did I correctly perform the SQL query below (photo attached): Create a query that is based on two…
A: The given query is performed correctly:SELECT COURSE_TITLE, COURSE_DESCRIPTION FROM COURSE INNER…
Q: upleads wp desc Has med title ed d wp name med name Img dese img id img type his week is to create…
A: According to the given problem statement we are required to create a SQL code that is used to make…
Q: Hello can you help me to connect my registration PHP which I don't know how to insert those…
A: ANSWER: Beneath the code which help to associate enrollment PHP to your information base:
Q: Q3. Mysql Information: MYSQL RDBMS Address: students.emu.edu. User Name: Q3 Password: shudent…
A: Here we write simple PHP code to get all requirements: ==================================
Q: Course: Database *(SQL)* Please excute the given SQL script…
A: The question is to write the SQL statements for the given queries. As this question is a multipart…
Q: Insert the following data into your database tables. STUDENTS STUDENT_ID STUDENT_NAME…
A: Solution:-- 1)The given data in the question are all those things that must be included in the…
Q: CUSTOMER Columns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire…
A: Actually, database is a used to stores the data\information.
Q: Question text Referring to the table below, what TYPE of data would you give to the 4h attribute?…
A: Answer : - option b) numeric
Q: Create the following tables in your database with the following schema: Table: Countries | Column…
A: As per our guidelines, only 3 sub parts will be answered. So, please repost the remaining questions…
Q: CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY…
A: Select name, ages from TABLE USERS, TRACKS where nationality='United States' join( LISTEN…
Q: Jump to level 1 Courseld CourseCode 1034 BUS739 6237 4074 2888 3587 BUS9 ENGL997 CS98 CS29 Course…
A: Given Table Course SELECT CourseCodeFROM CourseWHERE Capacity <=(SELECT Capacity FROM Course…
Q: Sample Value 214 Sample Value 235 Sample Value 214 Attribute Name MEMBER NUM MEMBER NAME Alice B.…
A: The primary key should be unique , so we can take INVITE_NUM as primary key, which gives unique…
Q: Create the following table in your database with the following schema: Table: Sales | Column Name |…
A: create table query- create table sales(sale_id int primary key ,product_name varchar(200),sale_date…
Q: Branch Table Column Name BR_ID Data Type NUMBER FK Description Each Branch will have a Unique Size…
A: Note: 1. we had make sure that foreign key at child table data type matches with parent table data…
Q: te the database and table in MYSQL, PhpMyAdmin as shown below in the screenshot: Database Name:…
A: CREATE DATABASE: Open PhpMyAdmin and create a new database, name it as Library_123 and then click…
Q: CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY…
A: Query The select statement is used for retrieving data from database. The data returned is stored…
Q: Create a table named "student" with the following columns/fields: 1. id - integer not null primary…
A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…
Q: Create a database with add and edit of the following: Customer ID Customer Name Product Amount Date…
A: CREATE TABLE customer (CustomerID INT PRIMARY KEY,Cust_Name VARCHAR(20),Age INT,Address…
Q: Q2. Convert ERD to Relational Schema. Employee ID Start Date Years Teaching Section ID Room 1…
A:
Q: Schema Table: CREATE TABLE name_basics (nconst VARCHAR(45) NOT NULL, primaryName VARCHAR(45) NULL,…
A: In SQL server creating trigger statement The CREATE TRIGGER statement is used to create a new…
Q: CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY…
A: The values inserted into the RECORD table using the query Insert into RECORD(artist_id,track_id)…
Q: Topic: Database Software: SQLite Schema Table: CREATE TABLE name_basics (nconst VARCHAR(45)…
A: This SQLite tutorial teaches you everything you need to know to start using SQLite effectively. In…
Q: this is a review question The SQL statements that answer these questions. please keep the answer…
A: SQL is Structured Query Language, which is a computer language for storing, manipulating and…
Q: Write an SQL statement using a subquery to list LastName, FirstName, and full mailing address of…
A: Answer:-
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Create the ERM. FIGURE Q3.22 THE CH03_THEATER DATABASE TABLES Database name: Ch03_Theater Table name: DIRECTOR DIR_NUM DIR 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 1002 Hold the Mayo, Pass the Bread 1003 I Never Promised You Coffee 1004 Silly Putty Goes To Washington DIR NUM 102 101 102 100 1005 See No Sound, Hear No Sight 101 1006 Starstruck in Biloxi 102 1007 Stranger In Parrot Ice 101Insert the following data into your database tables.STUDENTSSTUDENT_ID STUDENT_NAME STUDENT_SURNAMES123456 Neo PetleleS246810 Derek MooreS369121 Pedro NtabaS654321 Thabo JoeS987654 Dominique WoolridgeMODULESMODULE_ID MODULE_NAME MODULE_CREDITDATA6212 Database Intermediate 30INPU221 Desktop Publishing 20PROG6211 Programming 2A 15PROG6212 Programming 2B 15WEDE220 Web Development (Intermediate) STUDENT_MODULESSTUDENT_ID MODULE_IDS123456 PROG6211S123456 PROG6212S246810 DATA6212S369121 DATA6212S369121 INPU221S369121 WEDE220S987654 PROG6211S987654 PROG6212S987654 WEDE220LECTURERSLECTURER_ID LECTURER_NAME LECTURER_SURNAMEL578963 Kwezi MbeteL876592 Julia RobinsL916482 Trevor JanuaryLECTURER_MODULESMODULE_ID LECTURER_IDDATA6212 L578963INPU221 L876592PROG6211 L916482PROG6212 L916482WEDE220 L876592Correct INSERT statements used and all data correctly inserted per table.Identify the foreign keys. FIGURE Q3.22 THE CH03_THEATER DATABASE TABLES Database name: Ch03_Theater Table name: DIRECTOR DIR_NUM DIR LNAME DIR DOB 100 Broadway 101 Hollywoody 18-Nov-53 102 Goofy 12-Jan-65 21-Jun-62 Table name: PLAY PLAY CODE 1001 Cat On a Cold, Bare Roof 1002 Hold the Mayo, Pass the Bread PLAY NAME DIR NUM 102 101 1003 I Never Promised You Coffee 102 1004 Silly Putty Goes To Washington 1005 See No Sound, Hear No Sight 1006 Starstruck in Biloxi 1007 Stranger In Parrot Ice 100 101 102 101
- Create the table that would result from Tstu_code, dept_code (student a professor). FIGURE Q3.8 THE CH03_COLLEGEQUE DATABASE TABLES Database name: Ch03_CollegeQue Table name: STUDENT STU CODE PROF_CODE 100278 128569 2 512272 4 531235 2 531268 553427 1 Table name: PROFESSOR PROF CODE DEPT CODE 12 26 36 44 To upload and submit your assignment, click the Choose File button below to find and select your saved document. Make sure that the file is saved with your last name in the file name. (Example: ch3_review1_Jones.doc)The database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.Create the database and table in MYSQL, PhpMyAdmin as shown below in the screenshot: Database Name: Library YourlD Table Name: Books Field / Column Name Datatype with size Constraint BooklD Int Primary Key Author Varchar(50) Title Varchar(50) PublishedDate Date 160% 三 O目 O ITDB201 FINAL EXA.. Meeting now | O Type here to search 近
- Create the table that would result from Tstu_code (student). FIGURE Q3.8 THE CH03_COLLEGEQUE DATABASE TABLES Database name: Ch03_CollegeQue Table name: STUDENT STU CODE PROF_CODE 100278 128569 512272 531235 531268 2 553427 1 Table name: PROFESSOR PROF CODE DEPT CODE 12 26 36 44FIGURE P8.31 CH08_SALECO2 DATABASE TABLES Database name: Ch08_SaleCo2 Table name: CUSTOMER Table name: INVOICE CUS CooE CuS LNAMECUS PNAME CuS NMAL CUSAREACOCE CU PHONE CuS BALANCE OIE Rumas CO1 Dure W NUNGER | CUS_CO DATE 100 19014 16--1 1001 16Jan-18 TOTAL TA otAL Ahet Lre Kay 544 04-126 000 1070 19012 16n-t 10011 17an-18 10018 153S 0013 Obenki KCO14 Odundo Myren COS O 56 76 00 0.00 221 19 16 4-210 222-1 403 2-12 1004 100s 280 7044 James Gege 1000 10014 17an-18 10017 wane 15 10015 1tlan18 200 00 Fart 210 000 Are Clate 1001 t 1008 431 de 615 207-00 Table name: LINE WNUMEES DENUMBERCOCE| LHE UNTS UE PRICE UHE TOTAL Table name: PRODUCT 1499 149 1001 1DERO Power pairte, 15 pa, Seorz 13-02 per bde 140 900 p e 00 1000 499 130eo-17 140 1000 1.223/OPD 13Nv-17 15a1a 12 1749 000 21344 1000 3 13022 749 14 90 19.00 70.44 207 108 92 1000 1490 19 om H 10n,0 z Y DO gnew. 12n 15-n-1 23 43 199 20e-17 24ec1 1004 1006 22OHE 1 PVCZDRT 1 SM 1077 2 22OTY 9.06 ar 12 22ORD BIO conder I0 20He O hanmer 21LAA…The ABC Database Tables Table A TRUCK_NUM BASE CODE TYPE_CODE TRUCK_MILES TRUCK BUY DATE TRUCK SERIAL NUM 501 502 501 23-Sep-07 AA-322-12212-WM1 05-Feb-06 AC-342-22134-Q23 11-Nov-OS AC-445-78656-Z99 06-Jan-07 WVQ-112-23144-T34 01-Mar-06 FR-998-32245-W12 15-Jul-03 AD-456-00845-R45 17-Oct-04 AA-341-96573-284 07-Aug-05 DR-559-22169-D33 12-Feb-08 DE-887-98458-E94 1001 1032 1003 1004 1005 1006 1007 1009 1009 Table C Table B BASE CODE 501 502 Lexington 503 Cape Girardeau 504 Detton 503 501 502 502 T TYPE_CODE 503 BASE CITY Murfreesboro TYPE DESCRIPTION 1 Single box, double-sode 2 Single box, single-axde 3 Tandem trailer, single-exde 1 1 2 1 2 2 3 32 2 32123.5 76934.3 12346.6 2894.3 45673.1 193245.7 32012.3 44213.6 10932.9 BASE STATE BASE_AREA_CODE TN KY MO GA 615 568 456 901 BASE PHONE 123-4567 234-5678 345-6789 458-7890 BASE MANAGER Andree D. Gallager | George H. Delarosa Maria J. Talindo Peter F. McAvea
- name of table 1 Staff_info: Staffid (pk) Fname Lname Dob Genderid Course_code (fk) Gender_info: Genderid (pk) gender Course_info: Course_code (pk) Course_name Departid (fk) Depart_info: Departid (pk) Depart_name using the information above develop a database using mysql workbench and connect the tables to each other using the propper fk (foreign key) and pk (primary key) database name should be connectstaffUse Mysql code The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule for Feb 1, 2020 with the lesson date/time, student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date/time, then by the horse's registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results. Hint: Perform a join on the LessonSchedule, Student, and Horse tables, matching the student IDs and horse IDs.Database Schema The schema for the Ch07_FACT database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab. FIGURE P7.56 THE CH07_FACT ERD CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check_Out_Date Check_Due_Date Check_In_Date >0-----H- Pat_FName Pat LName Pat_Type BOOK AUTHOR PK Book_Num PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num PK,FK2 Au ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book,