We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

CS403 Assignment No 03 Spring 2019 Solution & Discussion

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 1508

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions. Read More>>

Discussed & be touched with this discussion. After discussion a perfect solution will come in a result at the end.

 

“How to Join Subject Study Groups & Get Helping Material”

 

P.S:    Please always try to add the discussion in proper format title like “CS101 Assignment / GDB No 01 Solution & Discussion Due Date: ___________”

 

Share below link with friends for solution & Discussion. A Single link for help in your education.

http://bit.ly/vucodes

 

Site Overview | Assignment Solutions | Past Papers |Site Features

SOLUTION Assignment No. 3 (CS403 – Database Management System) Spring 2019

With full details and explanation and guidance.

sir jo snapshot lagna hai woh code ka lagna hai jo ap ny show kiya hai?

Code sirf samjany ky liay hai. 

sir i am confuse snapshot kis chz ka lagna hai?

Boss, two very major issues are there.

  1. No Foreign Key Constraints.
  2. Insert clause have errors with date format...

CS403 ASSIGNMENT NO 3 IDEA SOLUTION

By Mani Siddiqui BS VII

CS403 ASSIGNMENT NO 3 IDEA SOLUTION

check attachtment 

Attachments:

CS403 – Assignment # 3
All queries


Create database <your vu id>

Right-click on your own database name and then click on “New Query” and then start typing an executing all these command sets one by one and take screenshots of them.

Create table Role (
Role_id int primary key not null,
Name varchar(50) not null
)

Create table Task (
Task_id nvarchar(50) primary key not null,
Title nvarcar(50) not null,
Creation_date date not null,
Deadline date not null,
Assigned_to int not null
)

Create table Users (
User_id int primary key not null,
Name varchar(50) not null,
R_U_FK int FOREIGN KEY REFERENCES Role(Role_id)
)

Create table DiscussionThread (
Thread_id varchar(50) primary key not null,
T_D_FK nvarchar(50) FOREIGN KEY REFERENCES Task(Task_id),
Title varcar(50) not null
)

Create table Messages (
Msg_id int primary key not null,
M_T_FK varchar(50) FOREIGN KEY REFERENCES DiscussionThread(Thread_id),
Message_body varchar(50) not null,
Sender_id int not null
)

Insert into Task values(‘T0001’, ‘Computer Science’, ‘01/01/2019’, ‘2019/01/15’, ‘1’);
Insert into Task values(‘T0002’, ‘Management Sciences’, ‘02/02/2019’, ‘2019/02/16’, ‘2’);
Insert into Task values(‘T0003’, ‘Mass Communication’, ‘03/03/2019’, ‘2019/03/17’, ‘3’);
Insert into Task values(‘T0004’, ‘Bio Informatics’, ‘04/04/2019’, ‘2019/04/20’, ‘4’);

Select*from Task

Insert into DicsussionThread values(‘Th001’, ‘T0001’, ‘BSCS’);
Insert into DicsussionThread values(‘Th002’, ‘T0002’, ‘BBA’);
Insert into DicsussionThread values(‘Th003’, ‘T0003’, ‘M.Sc. Zoology’);

Select*from DiscussionThread


Select*from Task where Task_id=‘T0001’;

RSS

Latest Activity

+ M.Tariq Malik replied to + M.Tariq Malik's discussion EDU302 Human Development and Learning Assignment No 01 Fall 2019 Solution & Discussion in the group EDU302 Human Development and Learning
41 seconds ago
Profile IconMian Ali, Muhammad Daniyal and Usman Mughal joined + M.Tariq Malik's group
3 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS508 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 12-11-2019 in the group CS508 Modern Programming Languages
3 minutes ago
+ !! SARAH replied to Rana Ali's discussion Tell some words in the Shan of Hazart Muhammad (S.A.W)
5 minutes ago
Hiba Sani joined + M.Tariq Malik's group
7 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion MTH301 Calculus II GDB Fall 2019 Solution & Discussion
8 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MTH301 Calculus II GDB Fall 2019 Solution & Discussion in the group MTH301 Calculus II
8 minutes ago
+ M.Tariq Malik added a discussion to the group MTH301 Calculus II
9 minutes ago
Preçîõûš replied to + M.Tariq Malik's discussion MGT101 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 13-11-2019 in the group MGT101 Financial Accounting
11 minutes ago
Hiba Sani replied to + M.Tariq Malik's discussion CS401 Assignment No 01 Fall 2019 Solution & Discussion in the group CS401 Computer Architecture and Assembly Language Programming
11 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion BIO201 Basic Cell Biology Assignment No 01 Fall 2019 Solution & Discussion in the group BIO201 Basic Cell Biology
13 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion BIO201 Basic Cell Biology Assignment No 01 Fall 2019 Solution & Discussion
14 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion BIO202 Biochemistry-I Assignment No 01 Fall 2019 Solution & Discussion in the group BIO202 Biochemistry-I
14 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion BIO202 Biochemistry-I Assignment No 01 Fall 2019 Solution & Discussion
14 minutes ago
+ M.Tariq Malik added a discussion to the group BIO201 Basic Cell Biology
14 minutes ago
Hiba Sani joined + M.Tariq Malik's group
14 minutes ago
+ M.Tariq Malik added a discussion to the group BIO202 Biochemistry-I
14 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MCM431 Development Communication Assignment No 01 Fall 2019 Solution & Discussion in the group MCM431 Development Communication
17 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion MCM431 Development Communication Assignment No 01 Fall 2019 Solution & Discussion
17 minutes ago
+ M.Tariq Malik added a discussion to the group MCM431 Development Communication
17 minutes ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service