The Library Information System PDF

Added on - 21 Apr 2020

  • 15

    Pages

  • 824

    Words

  • 102

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
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
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document