Your assignment must be uploaded before or on Tuesday 9th July 2013.
It should be clear that your assignment will not get any credit if:
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:
In this assignment you will focus only on the tasks given below:
Note: Use all concepts and techniques you have studied so far discussed particularly in lectures 24-33.
ENTITY RELATIONSHILP DIAGRAM OF Security Information System
show your efforts yara
post your problem i will guide you
Junaid mera SQl install hogya hai lakin agey database create he nhi hota :( main new database create krti hun tou apna id deti hun tou wo kehte hain i can't make new database in master :( plz guide me through this
that's because you have no rights to create it
simply use sql server authentication
in object explore
right click on top of tree view select server properties
in permission grant all permission on your login name
No its not working neither with SQL server authentication they are asking for login and pw and i don't know the login and pw :(
can u come to my pc through teamviewer Little chef?
during the instillation process the instillation wizard asked about the authentication if you entered mix mode instillation then it will ask password for 'sa'
anyway try this
open sql server
expand security in tree view
and check that your login name exist here if yes then click on it and check the rights
just right click on your name then properties
then in server roles
click on all checks
apply it and then try it will 100% work for you
and if you name login name is not there (windows login name) then
add it and assign server roles
also can do it by doing this
Start All Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> SQL Server Surface Area Configuration
Add New Administrator
Select 'Member of SQL Server SysAdmin role on SQLEXPRESS' and add it to right box.
have u submitted ur assignment?
yeah but not gonna share it
MR tariq share a very good solution just edit it with your id and submit it
junaid is sab se next kia krna hay >>> ye ju 1,2,3,4 steps batey hain .. next kia krna ?
then your ready to create your db just execute your queries
if confusion in it then post them here