logo

Computer Science Assignment: PHP and MySQL - Desklib

19 Pages2163 Words111 Views
   

Added on  2020-05-28

Computer Science Assignment: PHP and MySQL - Desklib

   Added on 2020-05-28

ShareRelated Documents
Running head: PHP AND MYSQLPHP and MySQL Based Library Website Name of the StudentName of the University
Computer Science Assignment: PHP and MySQL - Desklib_1
PHP AND MYSQL1Table of Contents1. Task 1:.........................................................................................................................................22. Task 2:.........................................................................................................................................43. Task 3:.........................................................................................................................................94. Task 4:.......................................................................................................................................135. Task 5:.......................................................................................................................................156. Task 6:.......................................................................................................................................157. Task 7:.......................................................................................................................................168. Task 8:.......................................................................................................................................17Bibliography:.................................................................................................................................18
Computer Science Assignment: PHP and MySQL - Desklib_2
PHP AND MYSQL21. Task 1:memberborrowbookauthorstaffloginMIDPKNameAgeAddressContact_NumberEmailimageBorrowIDPKMIDFKBIDFKSIDFKBorrow_DateReturn_DateBIDPKAIDNamePublisherYear_Of_PublishAIDPKNameAddressContact_NumberSIDPKNamePositionContact_NumberMIDPKUserIDPasswordFigure 1: Entity Relationship Diagram(Source: Created by Author)Author Table:AttributesData TypesKeyAIDVarchar (40)PrimaryNameVarchar (40)AddressVarchar (40)Contact_NumberInt (20)Book Table: AttributesData TypesKeyBIDVarchar (40)PrimaryAIDVarchar (40)Foreign (Reference to AuthorTable)NameVarchar (40)PublisherVarchar (40)Year_Of_PublishDate
Computer Science Assignment: PHP and MySQL - Desklib_3
PHP AND MYSQL3Borrow Table:AttributesData TypesKeyBorrowIDVarchar (40)PrimaryBIDVarchar (40)Foreign (Reference to BookTable)AIDVarchar (40)Foreign (Reference to AuthorTable)SIDVarchar (40)Foreign (Reference to StaffTable)Borrow_DateDateReturn_DateDateLogin Table: AttributesData TypesKeyMIDVarchar (40)PrimaryUserIDVarchar (40)PasswordVarchar (40)Member Table: AttributesData TypesKeyMIDVarchar (40)PrimaryNameVarchar (40)AgeInt (11)AddressVarchar (40)Contact_NumberInt (20)EmailVarchar (40)imageVarchar (40)Staff Table:AttributesData TypesKeySIDVarchar (40)PrimaryNameVarchar (40)PositionVarchar (40)Contact_NumberInt (20)
Computer Science Assignment: PHP and MySQL - Desklib_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Home Inventory Database: Software Tool Description, SQL Section, Security Measures, Testing and Validation Strategies
|7
|800
|134

Data dictionary and sql queries
|9
|630
|385

TRA Race Entry System Author: Name + Number.
|7
|471
|85

Database Fundamentals: ER Diagram, SQL Queries, Importance of ER Diagram, Legal Issues and Security Techniques
|20
|2283
|323

Using the General Hardware Corp. relational database to generate a batch of SQL Server scripts
|4
|1054
|212