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