Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.

CS403-Database Management System Assignment No.5 Solution and Discussion Fall Spring 2013Due Date 9th July 2013

Database Management System (CS403)

Assignment No.5

                                           Total Marks:    20

 

Deadline

Your assignment must be uploaded before or on Tuesday 9th July 2013.

 

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 is not submitted in .doc file.

 

Objectives

The objective of this assignment is:

Giving the idea of the most commonly used RDBMS for designing physical database systems i.e. SQL SERVER. It is used to design systems physically either through Query Analyzer OR Enterprise Manager.

 

Important things to consider before doing this assignment: 

 

  1. This Assignment is the continuation of Second Assignment. Taking in consideration the same case study of Security Information System, a conceptual database has been provided in the form of an ERD.
  2. Now you have to complete your next phase of the Database Development Process which is physical database design. You will create it by utilizing the ERD provided in the next page.
  3. Apply foreign key constraint at this stage.

 

Task Description:

 

In this assignment you will focus only on the tasks given below:

 

  1. Open the Query Analyzer, and then create a new database by your id, like a sample screenshot provided on the last page of this file. Then create all the tables in this database by using it.
  2. You are required to transform all entities into tables by CREARE TABLE.
  3. You have to transform all entity attributes into columns.
  4. Define appropriate data types of each attribute.
  5. Apply entity integrity constraint by defining primary key, and foreign key of each entity.
  6. Write an SQL query to insert one row to each of the table.
  7. Take screenshots of your work, and paste them in your solution file (.DOC file).

 

 

Note: Use all concepts and techniques you have studied so far discussed particularly in lectures 24-33.

 

 

 

ENTITY RELATIONSHILP DIAGRAM OF Security Information System

 

 

                                                              Sample Screenshot

GOOD LUCK

Spring%202013_CS403_5.doc

                

Views: 14296

Replies to This Discussion

aap nay jo folder extract kya hy us k andar 1 or file hay ex ki usay b run karay wo 1 jaga name managay ga aap say aap jo b nam day gay usay yad rakhyay ga phr install ho janay k bad aap jab usay run karo gay to wo aap say name or autentication mangay ga wo aap ko dyni paray ge problem solve ho jay ga

its simple folllow step

  1. Goto Programmes Sql server 2005
  2. Goto Configuration tool folder then click on Sql server surface area configuration
  3. Add new Administrator
  4. then follow the below pictures.

Your SQL Problem will be solved 100%

Gohar when you are trying to create the database doesn't have the necessary permissions in SQL Server.

Solution

To create the database:

  • Open the Security folder, then open the Logins folder and select the user account under which you want to create the database.
  • Open the account's Properties, select the Server Roles tab and then select the dbcreator checkbox (sysadmin works even better).

You can also try to create the database while logged in under the standard administrator account, sa.

agar in sab say masla hal na ho tu assign these roles to NT AUTHORITY\NETWORK SERVICE and DOMAIN\MACHINE_WITH_APPSERVER_NAME$.

it may solve your problem

Queries For SQL

Neha g aap is link se download ker lein upload ni ho ra soooooooooooooooori

http://care.dlservice.microsoft.com/download/5/2/9/529fef7b-2efb-43...

use window 7. Neha g ager aap na phla sql install kya hai to us ki service stop ker dein. process
Right click on my computer -->click on service --> stop sql services.
sql install kerna phla .net frame 3.5 and 4.0 b install krna ho ga. wesa 3.5 window 7 already hota hai bas us ko run kerna hai.

process to run .net frame 3.5 in window 7
control panel -->add or remove pro --> click (left side option) Turn window features on or off
-->run the .net 3.5

and 4.0 download

plzzzzzzzz bta dein kitna screenshot hun ga hamari assignment k. mean 6 hun ga ya all table 1 mein hi create krna hai? 

and her screenshot per hamari id hi ho gi ya jo table hai us table ka name ho ga?

AND entities hamari assignment ki ye hi hein EMPLOYEE, CAMARA, DEPARTMENT,IMAGE, VIDEO, ?

and plzzzzzz explain this line 

  1. Write an SQL query to insert one row to each of the table.

Cute Prince MCS jese main ki hai mera solution check karo wesy karni hai hai thek hai aur kuch ni karna is main insert ni karna q k Sir ne kaha he ni insert karne ka just table CREATE karne hain thek hai

aur ap bol rahy ho ik insert command b likhni hai. 

first of all you can download the microsoft SQL 2000 developer edition from www.4shared.com because this is only available from there and this is recommended by the instructor and his installation guide is also available from your lms. in this sql it is easy to create database and tables.. 

RSS

Looking For Something? Search Below

VIP Member Badge & Others

How to Get This Badge at Your Profile DP

------------------------------------

Management: Admins ::: Moderators

Other Awards Badges List Moderators Group

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

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