Download Database Design and Development Coursework: Library System and more Assignments Database Programming in PDF only on Docsity!
ASSIGNMENT 1 FRONT SHEET
Qualification TEC Level 5 HND Diploma in Computing
Unit number and title Unit 04: Database Design & Development
Submission date 3 /7/2020 Date Received 1st submission
Re-submission Date 7/7/2020 Date Received 2nd submission
Student Name Le Thanh Phuong Student ID GCD19 1157
Class GCD0805 Assessor name Hoang Nhu Vinh
Student declaration
I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I understand that
making a false declaration is a form of malpractice.
Student’s signature Phuong
Grading grid
P2 P3 P4 P5 M2 M3 M4 M5 D2 D
Summative Feedback: Resubmission Feedback:
Grade: Assessor Signature: Date:
Signature & Date:
ACKNOWLEDGEMENT First of all, I’d like to acknowledge the responsible persons from University of Greenwich who provide this coursework for students. I would like to thank to all the authors and researchers who researched about this data. Moreover, I would like to present my appreciation for our lecturer, for his great and expert lectures and guidelines. Last but not least, I would like to appreciate responsible teachers and staffs from our school for providing and creating such a good learning environment. Signature of Student(Electronic signature)
Le Thanh Phuong Database Design & Development Assignment 2
Table of Contents
Figure 1 Books Table Create Figure 2 Books Table Introduction Library System is a tool for schools and libraries that helps keep track of books and magazines lent to students and faculty. The Library System allows you to add an unlimited number of titles and users that need to manage, as well as send reminders to notify books that have not been returned to the library. Library System is a good choice for managing libraries in schools, helping to manage the amount of borrowed, returned, imported and exported books at the library easily and accurately, besides the Mail Management Software. The Institute issues detailed reports on the books' situation in the library. Implemention
1. Create table querries
1.1. Books Table
- This query give user information about books.
- This is the Books Table after excute create “Books query”
Figure 3 Members Table Create Figure 5 Category Table Create Figure 4 Member Table Figure 6 Category Table 1.2. Members Table
- This query get information of members.
- This is Members Table after excute create “Members query” 1.3. Category Table
- This query provides membership types
- This is Category Table after excute create “Category query”
Figure 11 Insert data of Books table Figure 10 Transaction Table Figure 12 Book Table Result
- This is Transaction Table after excute create “Transaction query”
2. Insert table querries
2.1. Insert data of Books table
- This query use for insert information of books
- This is the result of Books query after excute insert “Books query”
Figure 13 Insert data of Members table Figure 14 Members Table Result Figure 15 Insert Category Table Figure 16 Category Table Result 2.2. Insert data of Members table
- This querry use for insert information of members
- This is the Result of Members query after excute insert “Members query” 2.3. Insert data of Category table
- This querry use for insert type of members
- This the result of Category query after excute insert “Category query”
Figure 21 Database Diagram Figure 20 Transaction Table Result
- This is the result of Transaction query aftere excute insert “ Transaction query”
3. Database Diagram
- The generated implementation database diagram is the same as the original ERD. This design is appropriate for a system.
- This Diagram shows us which one is the primary key and which one is the foreign key and how they are connected in database
- We use the one-to-many relationship for Transaction. Because the transaction table is a collection of all remaining tables so members and librarians can exchange information with each other.
- Members table with Category table: One Category only contains 1 category_id. So we use the one-to-one relationship.
- Librarian table with Transaction table: One id only contains 1 librarian_id. So we use one-to- one relationship
- Books table with Transaction table One id only contains 1 book_id. So we use one-to-one relationship
- Members Table with Transaction table: One id only contains 1 member_id. So we use one-to- one relationship.
4. Explainations about any changes comparing to my design
- During the time when I code , the category table have errors.
- Primary key and foreign key of Category table have problem
- So I changed by deletting the foreign key and change the category table have only id and name.
Update
members
Information about books Register membership Display Transaction
- Overall, completing all of the above SRS will improve the system data management and improve the system by knowing user needs and making the system more convenient.
TESTING CASE
- Although the interface table above has been completed, we also have to test continuously to see if there are any errors Test-case Purpose Data Querries Expected result Actual result Sta tus Librarian- check Check all the books Bookname: Macaulay Owen (1 row affected) Pas s Librarian- check 2 Check all the books Bookname: Frozen (0 rows affected) Pas s Member- information Get information of members Membername : Bevis Dillard (1 row affected) Pas s Member- information 2 Get information of members Membername : Popper (0 rows affected) Pas s Information about books Get information of books BookID: 1 (1 row affected) Pas s Information about books 2 Get information of books BookID: 26 (0 rows affected) Pas s
User Interfaces It is the user's machine interface. Users can easily use the system or tool with essential interfaces Include:
- Login Menu
- Check Member’s Information
- Members View
- Select member to check Borrow and Return Date
- Upgrade Member
- Searching Books
- Register Membership
- Display Transaction
Figure 22 Login Menu
1. Login Menu
- This is Login Menu for Librarian to manage library.
