Unit 04: Database Design & Development

Added on - 09 Nov 2020

  • 25

    pages

  • 1310

    words

  • 12

    views

  • 0

    downloads

Showing pages 1 to 6 of 25 pages
ASSIGNMENT 1 FRONT SHEETQualificationTEC Level 5 HND Diploma in ComputingUnit number and titleUnit 04: Database Design & DevelopmentSubmission dateDate Received 1st submissionRe-submission DateDate Received 2nd submissionStudent NameStudent IDClassAssessor nameStudent declarationI certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism.I understand thatmaking a false declaration is a form of malpractice.Student’s signatureGrading gridP1M1D11
Summative Feedback:Resubmission Feedback:Grade:Assessor Signature:Date:Signature & Date:2
3
ContentsI.INTRODUCE..........................................................................................................................................................................................5II.SYSRTEM REQUIREMENTS....................................................................................................................................................................61.Real world scenario..........................................................................................................................................................................62.Data requirements for storage.........................................................................................................................................................63.Relationship between entities..........................................................................................................................................................7III.DESIGN RELATIONAL DATABASE SYSTEM FOR A SUBSTANTIAL PROBLEM (P1)............................................................................101.ER Diagram......................................................................................................................................................................................102.Convert ER Diagram to Relation Diagram.......................................................................................................................................123.Relational database system............................................................................................................................................................12IV.SYSTEM INTEERFACE DESIGN.........................................................................................................................................................19V.CONCLUSION......................................................................................................................................................................................25VI.REFERENCE LIST..............................................................................................................................................................................26I.INTRODUCEDatabases and database systems are an essential component of life in modern society: most of us encounter several activities everyday that involve some interaction with a database. The objective of this report is to design a relational database system usingappropriate design tools and techniques, with clear statements of user and system requirements. In this assignment, I will design arelational database system for the library management system, with clear statements of user and system requirements.4
II.SYSRTEM REQUIREMENTS1.Real world scenarioFPT University is expanding due to the growth in the number of students. However, FPT is currently facing difficulties in dealing withmanaging the university. And I will design a relational system for the library management system of BTEC FPT International College.Library management system is to reduce and solve the cumbersome manual management, so that the library can rise to a perfectelectronic management. This is a useful information and information system to meet the research and learning needs of students andlecturers in the school.The library of BTEC FPT International College currently has many books updated daily to serve the needs of students in borrowingbooks. System objectives are: Librarian, it provides all the details of the borrower, as well as the details of the library inventory; forstudents or ordinary users, it has two functions includes borrowing and returning books; the administrator can also record new books,delete old books and so on. Visitors can also enter the system without a registering user, but there are certain functional limitations.Library activities can be described as follows:-Once a book is imported, it will be saved by the librarian to the system including information: book ID, title, publisher, author,quantity, price, inventory date, type of book and book placement.-A student who wants to borrow a book must have a student card that includes the student ID, student name, and major. Eachstudent has only one student ID card. Students need to borrow books to know the loan date and return date. Besides, studentsneed to provide additional email, phone number to contact in case of need.-Library books are divided into categories such as: economics, foreign languages, information technology, etc.2.Data requirements for storageEntityDescription of EntityAttributeDescription of AttributeBookAll of books in libraryBookIDIt is a unique identifier foreach book in the libraryBookNameName of Book5
BookDescriptionDescription of BookPublisherPublisher of BookAuthorAuthor of BookStudentAll of students in the schoolStudentIDIt is a unique identifier forevery student in the schoolStudentAddressAddress of StudentStudentNameName of StudentStudentEmailEmail of StudentClassClass of StudentLibrarianAll of the librarians in libraryLibrarianIDIt is a unique identifier foreach librarian in the libraryLibrarianNameName of LibrarianLibrarianEmailEmail of LibrarianLibrarianAddressAddress of LibrarianLibraryAll branches in the school'slibrary management systemLibraryIDIt is a unique identifier foreach librarian branch of theschoolLibraryNameName of librarian branchBillBillIDIt is a unique identifier foreach bill in the libraryAll invoices in the libraryBillNameName of BillDayDate on the invoiceCategoryAll categories in libraryCategoryIDIt is a unique identifier foreach category of the bookCategoryNameName of Category3.Relationship between entities6
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document