CS403 Assignment No 3 Solution Spring 2018

CS403 Assignment No 3 Spring 2018

Dear Students, Here you can read or Download CS403 - Database Management Systems Assignment No 3 Solution and Discussion of Spring 2018. Assignment Due Date is 16 July, 2018. Total Marks are 20. This assignment covers lesson no. 1-8. We are here to facilitate your learning and we do not appreciate the idea of copying or replicating solutions. CS403 Assignment Solution File will be added Soon here. In the mean time also read previously shared CS403 Assignment No 2 Solution Spring 2018.

CS403 Assignment No 3 Solution and Discussion Spring 2018

CS403 Assignment 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.

Recommended : CS403 Current Mid Term Papers Spring 2018

CS403 Assignment Rules for Marking:

It should be clear that your assignment will not get any credit if:

• The assignment is submitted after due date 
• The assignment is copied 
• The assignment solution does not have own VU-ID as database name 
• The assignment solution has other student ID

CS403 Assignment 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.

Recommended : CS403 Current Mid Term Paper Fall 2016

Important Instructions related to Assignment:

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 )

CS403 Assignment No 3 Question:

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.

Please 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

Required Data base screenshot

Please Note: The assignment will be marked zero if the assignment solution does not have student own VU-ID as database name.

CS403 Assignment No 3 Solution Spring 2018

CS403 - Database Management Systems Assignment No 3 Solution has been added. If you have already solved this Assignment or want to share some thoughts let us know in comments section below. Please Be Patient and Bookmark our page.

Recommended: CS101 Assignment No 3 Solution Spring 2018

CS403 Assignment Solution Sample Preview

Solution File Sample Code Preview has been added with Solution File in .pdf format.

CS403 Assignment No 3 Solution file sample preview Spring 2018

Complete Code Of .sql File is Given Below:

CREATE DATABASE bc170200770; 
 
USE bc170200770; 
 
CREATE TABLE Customer   
( 
custID int primary key not null, custName varchar(255) not null, custAddress text not null, 
Email text not null, 
); 
CREATE TABLE Catagory   
( 
catID int primary key not null, custName varchar(255) not null, 
InitailRate int not null, 
); 
CREATE TABLE S_ervices   
( 
serID int primary key not null, serTitle varchar(255) not null, serDescription varchar(255) not null, serCharges int not null, 
); 
CREATE TABLE Food_Item 
( 
ItemID int primary key not null, ItemName varchar (255) not null, 
ItemDescription varchar(255) not null, ); 
CREATE TABLE Menu 
( 
MenuID int primary key not null, no_of_servings int not null, 
quantity int not null, 
no_of_items int not null, 
); 
CREATE TABLE Venue 
( 
venueID int primary key not null, 
V_location varchar (255) not  null, city varchar (255) not null, 
capacity int not null, 
V_description varchar (255) not null ); 
CREATE TABLE E_vent 
( 
eID int primary key  not null, 
eDATE date not null, 
TimeSlot time not null, 
); 
 
insert into Venue ( venueID, V_location, city, capacity, V_description) values ( '002', 'multan', 'multan', '120', 'not available currently') select * from Venue; 

CS403 Assignment Solution Download Link

Download  [ Solution File Upload Status : Done  ]