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

Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…
PL/SQL Display the first name and last name of all employees who work for department 50 or have a salary greater than 3500. Handle the exceptions like No Data Found and Invalid Cursor
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]
Consider the tables provided below and answer the following SQL questions: Table 1: Service SereicelD SereiceName Accounting. Security Maintenance Table 2: ServiceSetUp SereicelD SetupFee 2 3 4 100 300 350 Recurring 25 50 125 Tax 10% 11 9% Questions: Write insert statements to enter first two records into Table 1 as shown in above figure. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. Display the name of the service that has setup fee greater than $300. d. Display average of tax rates for all services.
IN SQL Any user can create another user with the same privileges. Select one: a. True b. False
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.
In SQL With partial dependencies, data redundancies occur because every row entry requires duplication of data. Select one: a. True b. False
How to Grant access privileges on objects created in the future in sql.
Write an SQL statement that will insert an order in the orders table with the following data: cutomerID=3, orderDate = current date, shipAmount=20, taxAmount=23.56, shipDate=a week after current date, shipAddressID=3, cardType=2, cardNumber=4123123412341234, cardExpires=05/2024, billingAddressID=3 Write an SQL statement to delete all orders that are created between 2017-06-01 and 2017-06-07.