CS 403 Assignment No 03 Solution file.

Показать описание

Solution file Link is below: request ha k subscrb Lazmi kejia imandari sy
plzzzzzz....

Download Link:

you can also Download from

Assignment No. 03

SEMESTER Fall 2020
CS403- Database Management System

for Cs 401 assignment No3 Solution File

Total Marks: 20

Due Date: 26-01-2021

Instructions
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit if:
The assignment is submitted after due date.
The submitted assignment does not open or file corrupt.
The assignment is full or partially copied from (other student or ditto copy from handouts or internet).
Student ID is not mentioned in the assignment File or name of file is other than student ID.
The assignment is not submitted in .doc or .docx format.
Uploading instructions
Your submission must include:

Assignment should be in .doc or .docx format.
Assignment submission through email is NOT acceptable.
Objectives
The objective of this assignment is
To be able to understand relational data model.
To map Entity Relationship diagram to relational data model
To understand SQL commands

Note:
Your answer must follow the below given specifications.
Font style: “Times New Roman”
Font color: “Black”
Font size: “12”
Bold for heading only.
Font in Italic is not allowed at all.
No formatting or bullets are allowed to use.
Your answer should be precise and to the point, avoid irrelevant detail.

Deadline
Your assignment must be uploaded/submitted at or before 26th January, 2021.

Question Statement:

Our third assignment is the continuation of our second assignment.
The solution of the second assignment, i.e. the Entity relationship diagram is given below. This ERD will serve as an input to solve the third assignment.

Entity Relationship diagram (solution of second assignment):

You are now required to perform the following tasks according to above scenario.

Map the ER diagram to Relational data model and link the relations through primary key and foreign key.

After mapping ERD to relational data model, you are required to write the SQL commands for each of the following statements.

INSERT INTO Employee
(Emp_ID,Emp_Name,Emp_Gender,Emp_Address,Email,Contact#,Emp_DOB,Pro_ID)
VALUES

Show the names of all Managers whose Gender is Male.

Select Mgr_Name From manager Where Mgr_Gender=’Male’

Show the records of all Clients whose Project ID is PRJ002.

Select*from Client where pro_ID=’PRJ002’

Update the project id from PRJ01 to PRJ001 in Client relation.

UPDATE Client
SET pro_ID = PRJ001
WHERE Pro_ID=’PRJ01’

Change the name of Column from Email to Cl_Email in Client relation.

CLIENT_rename ‘Client_Email’ , ‘Cl_Email’ , ‘Column;

cs 403 assignment 3 Solution file.
sub sy request ha ......subcrb imandari k 7 kejia plzzzz........