logo

Create database `My_BIS325`;.

   

Added on  2019-09-26

3 Pages535 Words309 Views
Create database `My_BIS325`;CREATE TABLE `Employee` ( `first_name` varchar(50) NOT NULL, `last_name` varchar(75) NOT NULL, `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`));CREATE TABLE IF NOT EXISTS `Projects` ( `project_ID` int(11) NOT NULL AUTO_INCREMENT, `project_name` varchar(250) NOT NULL, PRIMARY KEY (`project_ID`));INSERT INTO `Projects` (`project_name`) VALUES ('Alpha'), ('Beta');project_ID attribute has value 1 and 2 for alpha and beta project_name because we have assigned auto increment to this field.INSERT INTO `My_BIS325`.`Employee` (`first_name`, `last_name`, `middle_initial`, `home_phone`, `social_security_number`, `home_address`, `home_state`, `home_city`, `salary`,

End of preview

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

Related Documents
STUDENT NAME:. 11 October 2016. SQL HW #3: DDL and DML
|4
|398
|232

Personal Playground Database System: Codio Platform
|13
|2243
|125

Draft SQL Implementation Assignment
|12
|1254
|190