Database Management System (CS403) Assignment No. 03 Solution Jul 15, 2018
Get Unique paid solution for this assingment.Cost 2000 rupees. Mail on projecthelp77@gmail.com
Assignment No.Three Dated:Jul 10, 18
Database Management System (CS403)
Assignment No. 03 – Open
Dear Students,
Assignment No. 03 of the difficulty Database Management System (CS403) has been uploaded, before submitting the project on LMS, please study all instructions given in the challenge record very well.
Due date of the task is “sixteen July, 2018”.
How to submit project No.3:
You are required to install square server 2005 or 2008.
Make database by using CREAT DATABASE command in question analyzer and run. Then take display screen shot of the given query. Also repeat the identical method for all tasks given in task file.
Past all display screen shots of the queries and output in MS Word document and submit on lms.
SQL Server Installation:
You are required to go to lms and down load square server 2005 or 2008 as in step with your hardware requirements.
Tutorials and video file has been uploaded on lms for SQL Server installation and use for the above versions 2005 and 2008 most effective.
Note: If you’re the use of different model of SQL Server and window then you have to search for hardware or software program requirement over net.
Online SQL Server Compiler or Editor:
For the ones college students who can’t install SQL Server may additionally go to net for on line SQL Server editor and provide solution of all obligations given in task document.
You may also go to the provided links. These are unfastened on-line compilers or editors that might not work nicely. In such case you have to search different hyperlinks to run all SQL server commands effectively.
Http://rextester.Com/l/sql_server_online_compiler
http://rextester.Com/ICGY32404
Note: No undertaking may be commonplace via email.
Regards,
Instructor CS403
Uploading instructions:
· Your task should be in .Doc /.Docx layout.
· Save your assignment together with your ID (e.G. Bc000000000.Document).
· No challenge might be established through e mail.
Rules for Marking:
It should be clear that your task will not get any credit score if:
The assignment is submitted after due date
The task is copied
The project answer does no longer have very own VU-ID as database name
The task answer has other pupil ID
Objectives
The cause of this venture is to permit college students to apply equipment to convert ER data model in to Relations/ Tables by using RDBMS.
Important things to consider before doing this task:
This challenge is based totally at the previous assignment (Assignment No.2 solution) as given beneath.
CUSTOMER(custID, Name, address, e mail)
CATEGORY(catID, catName, intialRate)
SERVICES(serID, serTitle, serDescription, serCharges)
FOOD-ITEM( itemID, itemName, description)
MENU(menuId, no.Of.Serving, Quantity, no.OfItems )
VENUE(region, town, capability, description)
EVENT(eId, Date, timeSlot )
You are required to very well examine the above family members and put in force these relations the usage of RDBMS (SQL Server).
You are required to write down and run “SQL Commands” in question analyzer and offer answer of the subsequent tasks via attaching or pasting screen photographs of every command in MS Word document:
Create database with CREATE DATABASE command. The name of your database have to be your VU ID.
Transform all relations into tables by using CREARE TABLE command with all columns gift in the above family members.
Define appropriate information varieties of every attribute or column using SQL Command.
Insert a unmarried record in “EVENTS” table using SQL Command.
Display the inserted file of “EVENTS” desk the use of SQL Command.
Note: You are required to Run SQL Queries for all the given duties and fasten display screen shots of the specified instructions and outputs one by one as proven in underneath sample display shot.
Open the Query Analyzer, after which create a new database via your identity, like a sample screenshot
Note: The venture might be marked zero if the project solution does not have scholar personal VU-ID as database name.
