[go: up one dir, main page]
Scribd
Upload
20 views1 page

Create Database Fastfood

Uploaded by

Noorul Ahilah Thameem
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
20 views1 page

Create Database Fastfood

Uploaded by

Noorul Ahilah Thameem
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

create database bhaskarusmanlancy;

use bhaskarusmanlancy;

create table productdetails(fcode int(5) primary key, fname char(30), fqty


int(5), fprice decimal(12,2),fprofit int(2),fsprice decimal(12,2),ftype
char(20));

create table prisondata(pid int(5) primary key, pname char(25), cellno


char(5),durationinmonths int(3), page int(3), typeofcrime
char(100),entrydate date,releasedate date);

create table bill(fbcode int(5) references productdetails(fbcode),fbdate


date,fcode int(5),fbname char(30),fbprice decimal(12,2),fbqty int(5),fbtot
decimal(12,2));

You might also like