1 / 5

Situation

2-708-04 Information Technology in organizations Lab sessions : Access 1 Creating the database Library. Situation . Your neighborhood library needs a new information system to improve its performance of loan management.

aden
Télécharger la présentation

Situation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 2-708-04 Information Technology in organizations Lab sessions : Access 1Creating the database Library

  2. Situation Your neighborhood library needs a new information system to improve its performance of loan management. Recently the members were complaining about the fines for the delays. Moreover, the bookkeeper is unable to answer their questions about book delays. As you are a good Samaritan and active member of the library, you propose a design for the data base in order to keep track of books.

  3. The situation Key words • Name, FirstName, Address, telephone, Memberbirth date • Book title, purchase date, purchaseprice, book type, Key-words, • Name and FirstName of authors, birth and death date • Loans, delays and fines

  4. Loan A more complete solution: LoanId LoanDate ReturnDate Fine are made by (1,1) Member takes out (0,N) MemberCode FirstName NameAddressTelephoneBirthDate Copy Involves (1,1) is of (1,1) CopyNo PurchaseDate Price are involved in (0,N) Author Has (1,N) AuthorCode FirstName Name BirthDateDeathDate writes (1,N) Book ISBN Title Key-words Type are written by (1,N)

  5. Exercice to do : • Create the table Member with the corresponding fields. • Set the type of data to be entered in each field. • Check the properties of fields. • Identify the field or fields for the primary key. • Create the other tables. • Insert a few data in each table. • Determine the relations between tables. • Visualise the structure.

More Related