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

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: 1442

.

+ 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

is assignment ko jis software may karna hai wo run nhe ho raha plz koe to help kar day ajj extend date hai 

 g sister ap online ao may ap ki help kr daita hu, meri b assignment almost bn gai. thnx GOD. 

plz anybody help me

windows 7 main ye thek se nhi chal rha ap main se agr kisi ne inko run kia ho to btao plzz

koi solution :O

mera sql server he open nhi ho raha 

anybody plz hlp me 

Plz koi batay ga k n mn sy knsa select krna ha 

ans me  ..........................

Attachments:

same problem with me Momal  koe help b nhe kar raha

RSS

Latest Activity

彡Tweety彡 ❤️ replied to + Iuuoɔǝut +'s discussion Phly Dosti phir mohabbat ......
4 minutes ago
KAMRAN replied to + M.Tariq Malik's discussion MGT611 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group MGT611 Business & Labor Law
23 minutes ago
+ Abb@s replied to + Iuuoɔǝut +'s discussion Phly Dosti phir mohabbat ......
23 minutes ago
Profile IconKAMRAN and kiran ashraf joined + M.Tariq Malik's group
29 minutes ago
zohaib joined + M.Tariq Malik's group
47 minutes ago
+Umar Amin+ liked +Umar Amin+'s discussion Happy Birthday to my sweet and lovely friend mmm
2 hours ago
+Umar Amin+ liked +Umar Amin+'s discussion Happy Birthday to my sweet and lovely friend mmm
2 hours ago
Mahi Malik is now friends with M Aqib, Makhdoom Shahrukh Jamil and IBS
2 hours ago
IBS replied to MIT's discussion Visual Programing (CS411) Assignment#01 Deadline Date = 18-11-2019 in the group CS411 Visual Programming
3 hours ago
Ammara replied to + M.Tariq Malik's discussion MTH501 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 19-11-2019 in the group MTH501 Linear Algebra
3 hours ago
kiran ashraf replied to + M.Tariq Malik's discussion MGT611 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019 in the group MGT611 Business & Labor Law
3 hours ago
M IDREES replied to + M.Tariq Malik's discussion CS502 Fundamentals of Algorithms Assignment No 01 Fall 2019 Solution & Discussion in the group CS502 Fundamentals of Algorithms
3 hours ago
°`·("آفروز") aFFrOzE·´° replied to + M.Tariq Malik's discussion CS401 Assignment No 01 Fall 2019 Solution & Discussion in the group CS401 Computer Architecture and Assembly Language Programming
4 hours ago
Profile Icon°`·("آفروز") aFFrOzE·´°, Aamir Abbas and Rizwan Ali joined + M.Tariq Malik's group
4 hours ago
M IDREES replied to + M.Tariq Malik's discussion CS502 Fundamentals of Algorithms Assignment No 01 Fall 2019 Solution & Discussion in the group CS502 Fundamentals of Algorithms
4 hours ago
M IDREES replied to + M.Tariq Malik's discussion CS502 Fundamentals of Algorithms Assignment No 01 Fall 2019 Solution & Discussion in the group CS502 Fundamentals of Algorithms
4 hours ago
Ammara commented on + M.Tariq Malik's group MTH501 Linear Algebra
4 hours ago
Ammara joined + M.Tariq Malik's group
4 hours ago
+ Haxan updated their profile
4 hours ago
+ "αяsαℓ " Ќąƶµяɨ •" posted a discussion
4 hours ago

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

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