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

4 Pages398 Words232 Views

Added on 2019-09-21

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

Added on 2019-09-21

BookmarkRelated 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

End of preview

Want to access all the pages? Upload your documents or become a member.

Create database `My_BIS325`;.

|535

|309

KC7013 DATABASE MODELLING | SQL

|26

|3569

|10

Draft SQL Implementation Assignment

|12

|1254

|190

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