The Library Information System PDF

Added on - 21 Apr 2020

  • 15

    pages

  • 824

    words

  • 49

    views

  • 0

    downloads

Showing pages 1 to 4 of 15 pages
DESIGN A DATABASE
Table of Contents1.Enterprise Rules..........................................................................................................................12.Tables............................................................................................................................................13.Table Fields..................................................................................................................................24.ER Diagram.................................................................................................................................45.Sample Data.................................................................................................................................56.Query............................................................................................................................................67.Form.............................................................................................................................................78.Report.........................................................................................................................................109.Password.....................................................................................................................................1110.CRUD Access.........................................................................................................................1211.Database backup and recovery procedures.........................................................................121
1.Enterprise RulesThe entity rules are used to describe the relationship between the organizations entitieswith respect to the attributes domain, degree of relationship and membership class. Itsometime necessary to create the assumption about the degree of relationship andmembership class. These assumptions are must be documented as the data model part and itchecked by the system analyst for accuracy.2.TablesThe Library Information System Database tables are listed below.Book Title TableBorrower TableTable LIS2
Table LoanTable Reservations3.Table FieldsTable fields are listed below.For Book Title table,3
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