We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
+ Link For Assignments, GDBs & Online Quizzes Solution |
+ Link For Past Papers, Solved MCQs, Short Notes & More |
Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion
How to Add New Discussion in Study Group ? Step By Step Guide Click Here.
CS403 Assignment No 03 Spring 2019 Solution & Discussion
Tags:
+ 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?.
+ 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)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.
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.
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’;
© 2019 Created by + M.Tariq Malik.
Powered by
Promote Us | Report an Issue | Privacy Policy | Terms of Service
VU Students reserves the right to delete profile, which does not show any Activity at site nor has not activity more than 01 month.
We are user-generated contents site. All product, videos, pictures & others contents on vustudents.ning.com don't seem to be beneath our Copyrights & belong to their respected owners & freely available on public domains. We believe in Our Policy & do according to them. If Any content is offensive in your Copyrights then please email at m.tariqmalik@gmail.com or Contact us at contact Page with copyright detail & We will happy to remove it immediately.
Management: Admins ::: Moderators
Awards Badges List | Moderators Group
All Members | Featured Members | Top Reputation Members | Angels Members | Intellectual Members | Criteria for Selection
Become a Team Member | Safety Guidelines for New | Site FAQ & Rules | Safety Matters | Online Safety | Rules For Blog Post