ICTDBS502 - Design a database

15 Pages824 Words321 Views

Design a database (ICTDBS502)

Added on 2020-04-21

ICTDBS502 - Design a database

Design a database (ICTDBS502)

Added on 2020-04-21

BookmarkRelated Documents

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

End of preview

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

Advanced Data Management System Assignment

|30

|1970

|220

ICTDBS502 - Design a database