We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

AOA Everyone!

Hello everybody. Make your new database where you've write you VUID after this press ok button you've to click it then anywhere you'll see something is executing when it will executed it will show you complete then you've to click new query and then:

  • you've to write use bc1234567 whatever is your VUID and semicolon and then again you've to press F5 or exclamatory sign then it will execute.
  • or
  • you've to write CREATE DATABASE and your VUID; press f5 or exclamatory sign then
  • you've to write use bc1234567 whatever is your VUID and semicolon and then again you've to press F5 or exclamatory sign then it will execute.

there is no error in this, 
please follow these step then check it will be error free
write
CREATE DATABASE bc12345678;
then press F5 key for execution
then write
USE bc12345678;
then again press F5 for execution,
then create your all tables one by one then execute each line one by one

for creating the tables

CREATE TABLE Customer (

CID char (20) primary key,

CName varchar (50),

Address varchar (100),

Phone char (10)

)

************************************************** *****************...

CREATE TABLE _Order (

Order_ID char (10) primary key,

_Description varchar (100),

CID char (20) references Customer (CID)

)

************************************************** **************************

CREATE TABLE Product (

PID char (10) primary key,

PName varchar (50),

Price real,

Cat_ID char (10) references Category (Cat_ID)

)

************************************************** *****************...

CREATE TABLE Product_Order (

Order_ID char (10)

PID char (10)

Primary key (Order_ID, PID)

)

CREATE TABLE Invoice (

Inv_ID char (10) primary key,

_Description varchar (100),

Total_Amount real

Order_ID char (10) references _Order (Order_ID)

)

************************************************** **************************

CREATE TABLE Category (

Cat_ID char (10) primary key,

CatName varchar (50)

)



************************************************** **************************

CREATE TABLE Vendor (

Ven_ID char (10) primary key,

_Name varchar (50),

Address varchar (100)

)

CREATE TABLE Product_Vendor (

PID char (10),

Ven_ID char (10),

Primary key (PID, Ven_ID)

) Assignment No_4

Data Base Management System

Total Marks = 20

Solution:

CREATE TABLE Customer (

CID char (20) primary key,

CName varchar (50),

Address varchar (100),

Phone char (10)

)

************************************************** *****************...

CREATE TABLE _Order (

Order_ID char (10) primary key,

_Description varchar (100),

CID char (20) references Customer (CID)

)

************************************************** **************************

CREATE TABLE Product (

PID char (10) primary key,

PName varchar (50),

Price real,

Cat_ID char (10) references Category (Cat_ID)

)

************************************************** *****************...

CREATE TABLE Product_Order (

Order_ID char (10)

PID char (10)

Primary key (Order_ID, PID)

)

CREATE TABLE Invoice (

Inv_ID char (10) primary key,

_Description varchar (100),

Total_Amount real

Order_ID char (10) references _Order (Order_ID)

)

************************************************** **************************

CREATE TABLE Category (

Cat_ID char (10) primary key,

CatName varchar (50)

)



************************************************** **************************

CREATE TABLE Vendor (

Ven_ID char (10) primary key,

_Name varchar (50),

Address varchar (100)

)

CREATE TABLE Product_Vendor (

PID char (10),

Ven_ID char (10),

Primary key (PID, Ven_ID)

)


Enjoy alls 

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 1444

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

Assignment No_3

 

Data Base Management System

Total Marks = 20

Solution:

CREATE TABLE Customer (

CID char (20) primary key,

CName varchar (50),

Address varchar (100),

Phone char (10)

)

 

************************************************** *****************...

 

CREATE TABLE Product (

PID char (10) primary key,

PName varchar (50),

Price real,

Cat_ID char (10) references Category (Cat_ID)

)

 

************************************************** *****************...

 

CREATE TABLE Product_Order (

Order_ID char (10)

PID char (10)

Primary key (Order_ID, PID)

)

CREATE TABLE Invoice (

Inv_ID char (10) primary key,

_Description varchar (100),

Total_Amount real

Order_ID char (10) references _Order (Order_ID)

)

 

**************************************************

 


CREATE TABLE Vendor (

Ven_ID char (10) primary key,

_Name varchar (50),

Address varchar (100)

)

CREATE TABLE Product_Vendor (

PID char (10),

Ven_ID char (10),

Primary key (PID, Ven_ID)

)

 

 

Assignment No_4

Data Base Management System

Total Marks = 20

 

Solution:

CREATE TABLE Customer (

CID char (20) primary key,

CName varchar (50),

Address varchar (100),

Phone char (10)

)

************************************************** *****************...

CREATE TABLE _Order (

Order_ID char (10) primary key,

_Description varchar (100),

CID char (20) references Customer (CID)

)

************************************************** **************************

CREATE TABLE Product (

PID char (10) primary key,

PName varchar (50),

Price real,

Cat_ID char (10) references Category (Cat_ID)

)

************************************************** *****************...

CREATE TABLE Product_Order (

Order_ID char (10)

PID char (10)

Primary key (Order_ID, PID)

)

CREATE TABLE Invoice (

Inv_ID char (10) primary key,

_Description varchar (100),

Total_Amount real

Order_ID char (10) references _Order (Order_ID)

)

************************************************** **************************

CREATE TABLE Category (

Cat_ID char (10) primary key,

CatName varchar (50)

)



************************************************** **************************

CREATE TABLE Vendor (

Ven_ID char (10) primary key,

_Name varchar (50),

Address varchar (100)

)

CREATE TABLE Product_Vendor (

PID char (10),

Ven_ID char (10),

Primary key (PID, Ven_ID)

)

 

 

Helping tips :

 

SQL SERVER. It is used to design systems physically either through Query Analyzer OR Enterprise Manager.

Dear make your new database where you've write you VUID after this

press ok button you've to click it then anywhere you'll see something is executing when it will executed it will show you complete then you've to click new query and then:

  • you've to write use bc1234567 whatever is your VUID and semicolom and then again you've to press F5 or exclamatory sign then it will execute.
  • or
  • you've to write CREATE DATABASE and your VUID; press f5 or exclamatory sign then
  • you've to write use bc1234567 whatever is your VUID and semicolom and then again you've to press F5 or exclamatory sign then it will execute.

STEP1 : CREATE DATABASE bc12345678;
STEP2 :press F5 key for executio
STEP3 : write and USE ID
STEP4:again press F5 for execution,

STEP5 :create your all tables one by one then execute each line one by one

Where to find sql server :

 

LMS se install ker len SQL 2000 n latest dono hi available hen udher 

lms may to parts may hai softwre to samaj nhe a rahe konsa karna hai

bddyz servar name kia likhoon...?

code error show krrha he uska hi screan shot lelein

 

how to make this assignment ???? i have sql

i cant intall sql sever

damn

RSS

Latest Activity

+ Danial replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Happy Marriage to "Zee" & " Nomi weds Noor"....!
2 hours ago
Aijaz khan posted a discussion
2 hours ago
khurram us salam replied to + M.Tariq Malik's discussion ACC501 GDB Fall 2019 Solution & Discussion in the group ACC501 Business Finance
3 hours ago
khurram us salam joined + M.Tariq Malik's group
3 hours ago
+ ՏhehαrZααD + replied to + ՏhehαrZααD +'s discussion Assalamu Alaikum
3 hours ago
+ ! ! ! ! ! Blu Moon replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Happy Marriage to "Zee" & " Nomi weds Noor"....!
4 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut +'s discussion After and Before Marriage situations
4 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut +'s discussion Rules for Happy Marriage Life
4 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked +***piya o ry piya***+'s discussion eng201
4 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked 彡JK彡 ❤️'s discussion جسکی سنو وہی فرشتہ
4 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + ! ❤INNOCENT❤'s discussion Faqeer
4 hours ago
+++"MinShah"+++ updated their profile
4 hours ago
abdul bari updated their profile
4 hours ago
Zain Arshad replied to + M.Tariq Malik's discussion ENG201 Business and Technical English Writing Assignment No 01 Fall 2019 Solution & Discussion in the group ENG201 Business and Technical English Writing
4 hours ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Happy Marriage to "Zee" & " Nomi weds Noor"....!
4 hours ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Happy Marriage to "Zee" & " Nomi weds Noor"....!
4 hours ago
+ "αяsαℓ " Ќąƶµяɨ •" and Isha Chuhdary are now friends
4 hours ago
Waseem Aziz added a discussion to the group MGMT627 Project Management
4 hours ago
Waseem Aziz added a discussion to the group STA630 Research Methods
4 hours ago
Waseem Aziz joined + M.Tariq Malik's group
4 hours ago

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

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