Download Online Library System: Database Design and Development and more Assignments Mathematics 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 16 th^ Dec, 2021 Date Received 1st submission Re-submission Date Date Received 2nd submission Student Name Nguyen Duc Quang Student ID GCH Class GCH090 8 Assessor name Han Minh Phuong 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 Quang Grading grid
P1 M1 D
Contents Table of Figure ............................................................................................................................................................................................................... 3 P1: Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements………………………………………................................................................................................................................................................. 4 I, Statements of user and system requirements: ................................................................................................................................................ 4 1: Overview about the problem:............................................................................................................................................................................... 4 2: Requirements of the application: ....................................................................................................................................................................... 4 II, Design the relational database system:............................................................................................................................................................. 6 1: Analyse the requirements:....................................................................................................................................................................................... 6 2: Database design with explainations: ............................................................................................................................................................. ….. 7
Introduction: Below is the preparation report for the development process, including:
- Clear statement of user and system requirements. The system must have at least 2 user roles, including business processes and statistical reports for FPT university administrators.
- Design the relational database system using appropriate design tools and techniques. It must contain at least four related tables. P1: Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements. I. Statements of user and system requirements a. Overview about the Problem Due to the growth of the number of students and books, and how to make the library reach more student. FPT university is currently having problem in improve their library system. So they ask our company to develop an academic system to manage the library, so I decided to develop Online Library System. This system not only help in manage book and student but also it more convenient for student to access the library online. b. Requirements of the application - Business process : o When a student want to borrow books, librarian will create a call card and then fill the card. This card obtain fully important information. o Librarian have fully access to manage the librarian o When it come to due date, librarian have reponsibility to inform student o When student return books back to library, librarian recives books and update the system o When new book arrive, librarian will update the system with new data - Business rules:
List of books that can be lent in the library N.o Book ID Title Author Publisher Status II. Design the relational database system
a. Analyse the requirements:
List of data should be stored: Call card : student ID, student name, class, book ID, titles, author, publisher, start date and due date. Student: Student ID, student name, class, gender, date of birth Books: Books ID, book titles, author, publisher, publishing year, status Author: ID, writer Publisher: ID, Imprint
b. Database design with explainations:
