Database Systems Research Paper

Database Systems Research Paper - Project Report Database...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Project Report Database Systems MCIS 630 Instructor: Dr. Junping Sun By Daniel C. Williams Graduate School of Computer and Information Sciences Nova Southeastern University August 7, 2010 Table of Contents
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Introduction The purpose of the report is an assignment to design and implement a database for a real mini world environment based on given database requirements written in natural language. Requirements There are several branches in a library system, and each branch has a branch number, branch name, location (address), and phone number. The branch number is a unique identifier for each branch. Each library branch owns a large volume of copies of various books, and each copy of a book has a copy number and associated cost. Each book has a book number, title, the number of pages of the books, the name of the publisher, the year of publishing, and list of authors of the book. Each library could own zero to several copies of the same book. The database might store the authors names of each book and other information. Frequently, there are many patrons who borrow copies of books. Each time when a patron borrow a copy of a book, the system automatically generates a transaction identification associated with the borrowing date and due date of the book loan. Each patron has a patron number, patron’s name, patron’s contact information such as postal address, phone number, and email address.
Background image of page 2
Partition the Sentences Homogeneous Groups Based on the requirements, the following statements describe the Entities that will become the basis of the ER Design. BRANCH - There are several branches in a library system. - Each branch has a branch number, branch name, location (address), and phone number. - Branch number is a unique identifier for each branch. - Each library branch can own zero to several copies of the same book. (BNumber, BName, Address 1, Address 2, City, State, Zip, Phone) BOOK - Each book has a book number, title, the number of pages of the books, the name of the publisher, the year of publishing and list of authors of the book. (ISBN, Title, Publishing, Year, Pages) PATRON - Each patron has a patron number, patron’s name, patron’s contact information such as postal address, phone number and email address. (PNumber, PName, Address, City, State, Zip, Phone, Email)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
COPYOFBOOK - Each book has a copy number and associated cost. (CNumber, Cost) BOOKAUTHOR - Each book has one or more authors. (ANumber, FName, Middle, LName) BOOKLOAN - Patrons borrow copies of books. - The system automatically generates a transaction identification associated with the borrowing date and the due date of the book loan. (LNumber, BorrowDate, Duration, Status, CNumber, PNumber) Assumptions - The database will be written in Oracle11g. -
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 42

Database Systems Research Paper - Project Report Database...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online