Assignment No.3 Dated:Jul 10, 18
Database Management System (CS403)
Assignment No. 03 - Open
Assignment No. 03 of the subject Database Management System (CS403) has been uploaded, before submitting the assignment on LMS, please read all instructions given in the assignment file thoroughly.
Due date of the assignment is “16 July, 2018”.
How to submit assignment No.3:
You are required to install sql server 2005 or 2008.
Make database by using CREAT DATABASE command in query analyzer and run. Then take screen shot of the given query. Also repeat the same procedure for all tasks given in assignment file.
Past all screen shots of the queries and output in MS Word file and submit on lms.
SQL Server Installation:
You are required to visit lms and download sql server 2005 or 2008 as per your hardware requirements.
Tutorials and video file has been uploaded on lms for SQL Server installation and use for the above editions 2005 and 2008 only.
Note: If you are using other version of SQL Server and window then you have to search for hardware or software requirement over internet.
Online SQL Server Compiler or Editor:
For those students who cannot install SQL Server may visit internet for online SQL Server editor and provide solution of all tasks given in assignment file.
You may visit the provided links. These are free online compilers or editors that may not work properly. In such case you have to search other links to run all SQL server commands correctly.
Note: No assignment will be accepted through email.
· Your assignment should be in .doc /.docx format.
· Save your assignment with your ID (e.g. bc000000000.doc).
· No assignment will be accepted through email.
Rules for Marking:
It should be clear that your assignment will not get any credit if:
The motive of this assignment is to enable students to use tools to transform ER data model in to Relations/ Tables by using RDBMS.
Important things to consider before doing this assignment:
This assignment is based on the previous assignment (Assignment No.2 solution) as given below.
CUSTOMER(custID, Name, address, email)
CATEGORY(catID, catName, intialRate)
SERVICES(serID, serTitle, serDescription, serCharges)
FOOD-ITEM( itemID, itemName, description)
MENU(menuId, no.Of.serving, Quantity, no.ofItems )
VENUE(location, city, capacity, description)
EVENT(eId, Date, timeSlot )
You are required to thoroughly observe the above relations and implement these relations using RDBMS (SQL Server).
You are required to write and run “SQL Commands” in query analyzer and provide solution of the following tasks by attaching or pasting screen shots of each command in MS Word file:
Note: You are required to Run SQL Queries for all the given tasks and attach screen shots of the required commands and outputs separately as shown in below sample screen shot.
Open the Query Analyzer, and then create a new database by your id, like a sample screenshot
Note: The assignment will be marked zero if the assignment solution does not have student own VU-ID as database name.
+ 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)
Bhi jaan please will you send me my d id screen shoot . my id is Bc160401184 and my gmail id is email@example.com
koi sql 2008 ka link day gaaaa
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.
For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.
For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.
Or visit this link
Please Click on the below link to see…
P.S: Please always try to add the discussion in proper format title like “CS101 Assignment / GDB No 01 Solution & Discussion Due Date: ___________”
Idea Solutions.....Please Write your own ID while creating new DB
(Net Slow tha So GDrive pe upload krna pari)
CHK THIS ONE DEAR....
Email, cell no, facebook personal links, links sharing for promotion any kind of site & youtube direct link sharing is not allowed at the site.
Although If you want to share the youtube video, then paste the embed codes here of the youtube video. Otherwise your comment / reply will be deleted. As well as your account will be deleted from the site. Thanks for understanding.
mujhy chahey pls
time bht short hai
kindly bhai mujhy bna den screen shoot
my id is BC170404433