+ Link For Assignments, GDBs & Online Quizzes Solution


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

Assignment No.3                                                           Dated:Jul 10, 18

Database Management System (CS403) 

Assignment No. 03 - Open


 Dear Students,

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.


Instructor CS403

Uploading instructions:


·         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:

  1. The assignment is submitted after due date
  2. The assignment is copied
  3. The assignment solution does not have own VU-ID as database name
  4. The assignment solution has other student ID



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:


  1. Create database with CREATE DATABASE command. The name of your database must be your VU ID.
  2. Transform all relations into tables by CREARE TABLE command with all columns present in the above relations.
  3. Define appropriate data types of each attribute or column using SQL Command.
  4. Insert a single record in “EVENTS” table using SQL Command.
  5. Display the inserted record of “EVENTS” table using SQL Command.  


  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)

Views: 6236

Replies to This Discussion

any idea

ہم رومرہ زندگی میں انضمام سرکٹ کا استعمال ذاتی کمپیوٹرز، سمارٹ فونزاور ٹیلی ویژن سے لےکر کاروں میں پوشیدہ الیکٹرانکس تک ہر جگہ کرتے ہیں. بہت سی مثالیں ہیں. جیسا کہ سائز کو کم کرنا، ایک چپ میں ذیادہ ایپلی کیشنز اور صلاحیتوں کا استعمال. تاہم، یہ ایک مشکل کام ہے جس میں مینوفیکچررز، ڈیزائنرز اور الیکٹرانک ڈیزائن آٹومیشن کی بہت بڑی کوششوں کی ضرورت ہوتی ہے.
جیسا کہ ہما رے معاشرے میں نینو اور بائیو ٹیکنالوجی کا استعمال ہرجگہ ہوتا ہے۔ یہ مصنوعات کی ذمہ داریاں بڑھانے کے لئے زیادہ اہم کردار ادا کرتے ہیں، اور ان سے مصنوعات کا معیاراور کارکردگی بہتر ہوتی ہے. اس چیلنج سے نمٹنے کے لئے ہمیں اپنے انجنیئروں کی نینو ٹیکنالوجی میں صلاحیت کو بڑهانے کی ضرورت ہے۔ اور نینو ٹیکنالوجی کے استعمال کو فروغ اور حقیقی زندگی میں اس کو لاگو کرنے کی کو‍‍‍شش کرنی چایئے۔ اور صرف ریاضی طور پر سختی کے نقطہ نظر کو لاگو کرنا ہوگا.
نینو الیکٹرانکس سے متعلق چار اہم چیلنج ہیں۔ ناکامی کے طریقہ کار کی شناخت، نانو کی مصنوعات کی کم پیداوار، اعداد و شمار کی رازداری کی کمی، اور وشوسنییتا پریکٹس کے قیام کی تیاری اور نانو دور کے ساتھ رکھنے کے لئے محققین.

plz koi banay dy cs403 ki assignment 

Bhi jaan please will you send me my d id screen shoot. my id is Bc160401184 and my gmail id is bc160401184@vu.edu.pk 

Too easy

fr ke do help 

sol mjhy btyen if u know,


yeh tu open he nai ho rhe File

koi banay kar he dy assignment 


Looking For Something? Search Below

Latest Activity

Siddiq khan kakar liked Siddiq khan kakar's blog post *******beshak mukhtasar raho magar mukhlis raho*****
1 minute ago
Mani Siddiqui Ex commented on Mani Siddiqui Ex's status
16 minutes ago
+ ! ! Pagal Dewani ! ! + posted discussions
1 hour ago
+ ! ! Pagal Dewani ! ! + liked Siddiq khan kakar's blog post *******beshak mukhtasar raho magar mukhlis raho*****
1 hour ago
+ ! ! Pagal Dewani ! ! + replied to + ! ! Pagal Dewani ! ! +'s discussion Single hone ka faeda
1 hour ago
+ ! ! Pagal Dewani ! ! + replied to + ! ! Pagal Dewani ! ! +'s discussion Single hone ka faeda
1 hour ago
Rabia liked + M.Tariq Malik's discussion BT301 Introduction to Biotechnology Assignment No 02 Fall 2020 Solution / Discussion Due Date: 25-01-2021
2 hours ago
+!!★彡 "Mannat"彡★✓ replied to + ꜞꜞ STrAnGEr ꜞꜞ +'s discussion غیر کی باتوں کا آخر اعتبار آ ہی گیا_
5 hours ago
+!!★彡 "Mannat"彡★✓ liked + ꜞꜞ STrAnGEr ꜞꜞ +'s discussion غیر کی باتوں کا آخر اعتبار آ ہی گیا_
5 hours ago
Naser Javed (BBIT-8) liked + !! Ήලᵯᵯℹ Ⲥⱨ !! +'s discussion !!!!TODAY MINE PRINCESS BASH DAY!!!!
6 hours ago
Zoha n replied to + !! Ήලᵯᵯℹ Ⲥⱨ !! +'s discussion !!!!TODAY MINE PRINCESS BASH DAY!!!!
7 hours ago
Zoha n liked + !! Ήලᵯᵯℹ Ⲥⱨ !! +'s discussion !!!!TODAY MINE PRINCESS BASH DAY!!!!
7 hours ago

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

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