![]() |
data flow diagram for cd library management system - Printable Version +- Free Academic Seminars And Projects Reports (https://easyreport.in) +-- Forum: General Talks (https://easyreport.in/forumdisplay.php?fid=1) +--- Forum: General Discussion (https://easyreport.in/forumdisplay.php?fid=4) +---- Forum: Projects and Seminars (https://easyreport.in/forumdisplay.php?fid=71) +---- Thread: data flow diagram for cd library management system (/showthread.php?tid=52622) |
data flow diagram for cd library management system - mozart_009 - 10-04-2017 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 |