Primary or foreign key, Basic Computer Science

Assignment Help:

QUESTION

Your Library is currently offering access to the Internet for its subscribers on a fee paying basis. Subscribers should make a booking for each slot of one hour in advanced and a log book is used for this purpose. A fee of Rs 50. is charged per hour.

Staff members also have access when the computers are idle and they also have to make an entry in the log book. However, access in free for staff members. Over several months, the data has been collected in a log book. Now the administration of the library is facing lots of problem to analyse the data.

Since you are acquainted with the creation of small desktop databases, you have been asked to design a database to store the above data.

a) State THREE problems that the administration might be asking (3 queries) and for which it will take a lot of time to get an answer from the log book.

b) Provide the following for the database design

i) Tables to be used

ii) The field names, data type and size of each field in the table

iii) The relationship between each table

Also indicate whether a field is a primary or foreign key.


Related Discussions:- Primary or foreign key

Discuss the roles of system analysts in detail, Question 1 Explain the ...

Question 1 Explain the following system design tools in detail System Flowcharts Decision tables Decision trees Organization charts Question 2 Write s

Describe four types of abstracts, QUESTION 1 Write short notes on cont...

QUESTION 1 Write short notes on controlled vocabulary indexing. QUESTION 2 (a) List five types of abstracts. (b) Describe four types of abstracts. QUESTION 3

Lines and Indentation in python , One of the first caveats programmers come...

One of the first caveats programmers come across when learning Python is the reality that there are no braces to point to blocks of code for class and function definitions or flow

Decision table , No charges are reimbursed to the patient until the deducti...

No charges are reimbursed to the patient until the deductible has been met. Hospital visits are reimbursed at 80% and Lab visits are reimbursed at 70%. Doctor''s office visits are

FCB files:Channels of communication , The use of manage files very much fac...

The use of manage files very much facilitates the creation of files and programmer can focus on other aspects of the programming lacking worrying on details which can be handled by

Concept of programming language, CONCEPT OF PROGRAMMING LANGUAGE: In o...

CONCEPT OF PROGRAMMING LANGUAGE: In order to communicate with other human beings, one needs some language or a medium. In the same way for solving problems, a programming  lan

Excell, grades computation

grades computation

Software engineering, assignment 1:architectural design 2: component des...

assignment 1:architectural design 2: component design

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd