Consider the information below and then answer the following questions. Database Name: DEdb Table Name: Department Depld DepName DepLocation int unsigned not null varchar(30) not null varchar(7) not null Table Name: Employee Empld EmpName EmpPhone Depld int unsigned not null varchar(30) not null int unsigned not null int unsigned not null 1- Write the necessary SQL commands to create and prepare the above database? - aic 2- Write the necessary SQL commands to create the mentioned tables? 9m 3- Write SQL commands to add 3 departments and 5 employees? Qu

Consider the information below and then answer the following questions. Database Name: DEdb Table Name: Department Depld DepName DepLocation int unsigned not null varchar(30) not null varchar(7) not null Table Name: Employee Empld EmpName EmpPhone Depld int unsigned not null varchar(30) not null int unsigned not null int unsigned not null 1- Write the necessary SQL commands to create and prepare the above database? - aic 2- Write the necessary SQL commands to create the mentioned tables? 9m 3- Write SQL commands to add 3 departments and 5 employees? Qu

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

oracle SQL
Write SQL statements to create at the two tables for the database. The tables must have at least three relevant columns with appropriate types, a primary key and at least one table should have a foreign key and the related foreign key constraints. CREATE TABLE students ( Student_id int NOT NULL PRIMARY KEY, Stud_firstname VARCHAR(30) NOT NULL, Stud_lastname VARCHAR(30) NOT NULL, Stud_email VARCHAR(80) NOT NULL UNIQUE advisor_id int, ); create table advisor ( advisor_id int not null primary key, stud_id int, adv_firstname varchar(30), adv_lastname varchar(30), foreign key(student_id) references students(student_id) ); [keep getting error, need help correcting]
Question 1: Listing the number of customers who rented more movies than customer number 112 write the query. *The trigger will be created by typing the SQL command, not the interface.
32-Create a SQL statement to Display the CID, CName, and RType from both tables using the NATURAL JOIN clause.
28-Create a SQL statement to Display the RID, RType and a new column that will multiply the RATE to 30 in the ROOMS table. Use the alias "30-day Rental Fee".
In SQL With partial dependencies, data redundancies occur because every row entry requires duplication of data. Select one: a. True b. False
Q11)?,Q12)?,Q13)?
LAB 2: SUBTASK 1: Fill in the following tables: as preliminary lab work (some are filled for your guidance) SUBTASK 2: Build the tables in Oracle Live SQL with your account according to the tables above. SUBTASK 3: Build the relations among the tables. Addresses Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry address_id V NO 1234567890 Customers Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry customer id V number NO Good_groups Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry good_group_id V number varchar2(10) NO
PLZ help with the following: The manager wants to add a new painter as an artist in the database. What would the insert statement look like? For a painter to be considered in the Artist database, the painter must have painted at least one painting, however, a painting might not be exhibited in a gallery. Based on these business rules, please insert one painting for the painter that you inserted in Q1. sql file CREATE TABLE GALLERY (GAL_NUM char(4),GAL_OWNER varchar(35),GAL_AREACODE char(3),GAL_PHONE char(8),GAL_RATE number);INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37);INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 );INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67);INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30); /* -- */ CREATE TABLE PAINTER (PTR_NUM char(4),PTR_LASTNAME varchar(15) NOT NULL,PTR_FIRSTNAME varchar(15) NOT NULL,PTR_AREACODE char(3),PTR_PHONE char(8));INSERT INTO PAINTER…