CS403 Assignment 3 Solution Spring 2018

Dear VU (Virtual University of Pakistan) Students, here you can read or Download CS403 – Data Base Management System Assignment No 3 Solution and Discussion of Semester Spring 2018. Assignment Due Date is 16 JULY, 2018. Total Marks are 20. We are here to facilitate your learning and we do not appreciate the idea of copying or replicating solutions. You can also like for latest update our Facebook page, YouTube channel and follow on Google+.

Uploading instructions:

1. Your assignment should be in .doc /.docx format.
2. Save your assignment with your ID (e.g. bc000000000.doc).
3. No assignment will be accepted through email.

Rules for Marking:

1. It should be clear that your assignment will not get any credit if:
2. The assignment is submitted after due date
3. The assignment is copied
4. The assignment solution does not have own VU-ID as database name
5. 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.

Deadline: Your assignment must be uploaded/submitted on or before.

Download Assignment Solution File:

Download MATH603 Assignment Solution by Clicking the Download Button Below in just single Click

Download   (Solution Files Share by Ghulam Mujtaba)

You can Also Download Midterm Solved Past Papers reference by Moaaz and Waqar Sidhu, Final term Solved Past Papers reference by Moaaz and Waqar Sidhu, GDB Solutions, Assignment Solutions, and Solved Quizzes files, PPT Slides, Handouts, Final term Short Notes, Mid Term Short Notes and NTS Guidelines.