Question

Purpose: The purpose of this assignment is to provide an opportunity for you to write SQL statements to create tables and insert data into tables.

Skills: Learn and practice the techniques of writing SQL statements using SQL Server Management Studio(SSMS).  

Knowledge: By doing this assignment you will learn to use SSMS and write SQL statements to create new tables and insert data into the tables.

Tasks:

1. Use the following figure for the tasks below:
2. [15 points] Write SQL statements to create the tables in the schema Company. Include the primary and foreign key constraints of the schema.
3. [15 points] Insert the records that are in the database.

Answer 1

create database client
use client

create schema company

create table company.student(sid int primary key, sname varchar(30), locationName varchar(40) )
create table company.courses(cid int primary key, cname varchar(30), sid int, foreign key(sid)
references company.student(sid) )

insert into company.student values(1001,'basant','US'),(1002,'ritu','INDIA'),(1003,'rani','CANADA')
insert into company.courses values(1,'JAVA',1001),(2,'C++',1002),(3,'DBMS',1003)

select *From company.student
select *from company.courses

DON'T FORGET TO HIT LIKE.

THANKS BY HEART.

COMMENT DOWN IF ANY PROBLEM.