Ask a question to Desklib · AI bot

Ask NowBETA

STUDENT NAME:. 11 October 2016. SQL HW #3: DDL and DML

4 Pages398 Words232 Views
   

Added on  2019-09-21

BookmarkShareRelated Documents
STUDENT NAME: 11 October 2016SQL HW #3: DDL AND DML SQL0 | P a g e
STUDENT NAME:. 11 October 2016. SQL HW #3: DDL and DML _1
1.Create database My_BIS325;2.CREATE TABLE Employee ( first_name varchar(50) NOT NULL, last_name varchar(75) , middle_initial varchar(1) , home_phone varchar(12) NOT NULL, social_security_number varchar(11) NOT NULL, home_address varchar(100) NOT NULL, home_state varchar(20) NOT NULL, home_city varchar(20) NOT NULL, Salary decimal(10,2) NOT NULL, Email varchar(100) NOT NULL, PRIMARY KEY (social_security_number));3.CREATE TABLE Projects ( Project_ID int NOT NULL AUTO_INCREMENT, Project_name varchar(250) NOT NULL, PRIMARY KEY (Project_ID));4.INSERT INTO Projects(Project_name) VALUES ('Alpha'); INSERT INTO Projects(Project_name) VALUES ('Beta');OUTPUT:5.INSERT INTO Employee(first_name, last_name, middle_initial, home_phone, social_security_number, home_address, home_state, home_city, salary, email) VALUES('Brian', 'Finnegan', 'Q', '215.670.9308', '123-45-6789', '1420 Pine St', 'PA', 'Philadelphia','17500', 'joeyjoejojojr_shabadoo@hotmail.com');SELECT * FROM Employee;1 | P a g e
STUDENT NAME:. 11 October 2016. SQL HW #3: DDL and DML _2

Found this document preview useful?

Related Documents
Create database `My_BIS325`;.
|3
|535
|309

KC7013 DATABASE MODELLING | SQL
|26
|3569
|10

Draft SQL Implementation Assignment
|12
|1254
|190