10-04-2017, 09:00 PM
DATABASE DESIGN
Login Details
Field Name Data Type Description Constraints
username Char Username Primary Key
password Char Password
level Char Level
CD Type
Field Name Data Type Description Constraints
CDtypeID varchar CD type Primary Key
typedesc Char Type description
CDformat Char CD Format
CD
Field Name Data Type Description Constraints
CDID varchar CDID Primary Key
CDtypeID varchar CD type
language Char Language
CDtitle varchar CD Title
CDcost money CD Cost
Actor char Actor
Director char Director
Musixdirector char Music Director
cdqty integer CD Quantity
nodisc integer No. of Disc
Member
Field Name Data Type Description Constraints
MemID varchar Member ID Primary Key
Fname char First Name
Lname char Last Name
Address varchar Address
Phno integer Phone Number
Email varchar Email ID
date datetime Date
Rent Return
Field Name Data Type Description Constraints
issueID varchar Issue ID Primary Key
MemID varchar Member ID
CDID varchar CD ID
memname varchar Member Name
cdtitle varchar CD Title
issuedate datetime Issue Date
duedate datetime Due Date
cost_day money Cost per Day
qty integer Quantity
CD Tracker
Field Name Data Type Description Constraints
trackername varchar Tracker Name
taddress varchar Address
contact integer Contact Number
email varchar Email ID
Autonum
Field Name Data Type Description Constraints
cdautonum varchar CD Autonum
Memautonum varchar Member Autonum
Rentautonum varchar Rent Autonum