Ask a question from expert

Ask now

Unit 04: Database Design & Development

25 Pages1310 Words697 Views
   

Added on  2020-11-09

Unit 04: Database Design & Development

   Added on 2020-11-09

BookmarkShareRelated Documents
ASSIGNMENT 1 FRONT SHEETQualificationTEC Level 5 HND Diploma in ComputingUnit number and titleUnit 04: Database Design & DevelopmentSubmission date Date Received 1st submissionRe-submission DateDate Received 2nd submissionStudent Name Student ID ClassAssessor 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
Unit 04: Database Design & Development_1
❒Summative Feedback: ❒Resubmission Feedback:Grade:Assessor Signature:Date:Signature & Date:2
Unit 04: Database Design & Development_2
3
Unit 04: Database Design & Development_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
Unit 04: Database Design & Development_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 for each book in the libraryBookNameName of Book5
Unit 04: Database Design & Development_5
BookDescriptionDescription of BookPublisherPublisher of BookAuthorAuthor of BookStudentAll of students in the schoolStudentIDIt is a unique identifier for every student in the schoolStudentAddressAddress of StudentStudentNameName of StudentStudentEmailEmail of StudentClassClass of StudentLibrarianAll of the librarians in libraryLibrarianIDIt is a unique identifier for each librarian in the libraryLibrarianNameName of LibrarianLibrarianEmailEmail of LibrarianLibrarianAddressAddress of LibrarianLibraryAll branches in the school's library management systemLibraryIDIt is a unique identifier for each librarian branch of the schoolLibraryNameName of librarian branchBillBillIDIt is a unique identifier for each bill in the libraryAll invoices in the libraryBillNameName of BillDayDate on the invoiceCategoryAll categories in libraryCategoryIDIt is a unique identifier for each category of the bookCategoryNameName of Category3.Relationship between entities6
Unit 04: Database Design & Development_6

End of preview

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

Related Documents
Unit 04: Database Design and Development
|23
|5941
|788

GES0903B Student ID: Nguyen Hoai Bao Class: GCS200283
|11
|2058
|64

Database Design and Developement
|33
|4277
|52

Database Design And Development
|20
|2419
|38

BTEC Level 4 HND Diploma in Business Unit Number and Title Unit 3: Human Resource Management
|40
|7449
|245

Unit 16: Cloud Computing Assignment
|39
|13651
|1383