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

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.  

http://rextester.com/l/sql_server_online_compiler

http://rextester.com/ICGY32404

 

Note:   No assignment will be accepted through email.

Regards,

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

 

Objectives

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.

+ 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: 6100

.

+ 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

Dr. Tariq Hanif

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.

Ye le solution DUA MAI YAD RKHNA

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 

Ye le solution DUA MAI YAD RKHNA

Attachments:

rock bhai muj tu bana dy assignment plz mera mysql run nhi kar rah meri id mc170200357 muhammadsalmankhan466@gmail.com iss per send kar dena plzplz 

kya app run krny me help kr skty han

mery sy SQL ni install hoo rha

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 

PLZzz mujhy assignment k screen shots behj skty ho kya aap my SQL server is not working correctly Bc160400991

Big man bhai plz assignment bana doid meri  mc170200357 mera run nhi kar rah mysql 

khankhan18825@yahoo.com fb id 

kindly mujhy b send kr den

mujh se sql server install ni ho rha

RSS

Latest Activity

+ Iuuoɔǝut + posted discussions
2 minutes ago
waseem khan updated their profile
9 minutes ago
Areeha Chuhdary liked 彡JK彡 ❤️'s discussion Army Public School and College Mangla........ Staff required!!
35 minutes ago
zobialatif joined + M.Tariq Malik's group
37 minutes ago
Fazal ur Rehman replied to MIT's discussion Visual Programing (CS411) Assignment#01 Deadline Date = 18-11-2019 in the group CS411 Visual Programming
47 minutes ago
Fazal ur Rehman joined + M.Tariq Malik's group
47 minutes ago
Aqsa batool updated their profile
1 hour ago
Muhammad Ishtiaq and Talha Asad are now friends
1 hour ago
Ikra butt joined + M.Tariq Malik's group
1 hour ago
SILA updated their profile
1 hour ago
Profile IconAbdul Kareem, Abdul Baseer, MIRZA UMER BAIG and 4 more joined Virtual University of Pakistan
1 hour ago
+ " J ɨ y ą ⋆ ❤ ⋆ updated their profile
1 hour ago
+ M.Tariq Malik liked 彡JK彡 ❤️'s discussion Army Public School and College Mangla........ Staff required!!
1 hour ago
彡JK彡 ❤️ posted discussions
2 hours ago
Aqsa batool liked Aqsa batool's profile
2 hours ago
+¢αяєℓєѕѕ gιяℓ liked + M.Tariq Malik's discussion Moazz Files For Mid Term Past Papers
2 hours ago
+¢αяєℓєѕѕ gιяℓ liked + M.Tariq Malik's discussion Moazz Files For Final Term Past Papers
2 hours ago
+¢αяєℓєѕѕ gιяℓ liked + M.Tariq Malik's discussion Waqar Files For Final Term Past Papers
2 hours ago
+¢αяєℓєѕѕ gιяℓ liked + M.Tariq Malik's discussion Zoology Mid Term Past Papers
2 hours ago
+¢αяєℓєѕѕ gιяℓ liked ٹمبکٹو's discussion محبّت اور دل - عشق مجازی
2 hours ago

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

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