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

Formulate linear programming problem, Question (a) A firm produces four...

Question (a) A firm produces four products: P , Q , R , and S . Each unit of product P requires two hours of milling, one hour of assembly, and $10 worth of in-process in

Ricochet wireless data network, The Internet is replete with great success ...

The Internet is replete with great success stories and sad failures. While it is always nice to hear about the successes, more can probably be learned from the failures. In this ca

List two i/o virtualization methods, Question 1 List two I/O virtualizatio...

Question 1 List two I/O virtualization methods. Based on different features compare these two methods Question 2 Discuss three areas considered by organizations to secure the

Define grid computing, Question 1 Define Grid computing Question 2 ...

Question 1 Define Grid computing Question 2 Explain Attribute-Based Programming Model for Grid Services Question 3 What are the characteristics that users/applicat

Disadvantages of manual records, Disadvantages of Manual Records  ...

Disadvantages of Manual Records  More manpower is required to record/storelretrieve the data.   Bulky paper records take up more space and this problem increases with

Multiple queues, I need to create mulitple queues assignment that run concu...

I need to create mulitple queues assignment that run concurrently. It is like a queue simulation with  number of checkouts with a random probability of clients, joining any one

Historical background of computers, Historical Background The br...

Historical Background The brief history of the growth of computers is given below: Abacus:   It was the first mechanical device developed approximately 3,000 year

Neural Network, The following data set describes whether a given coordinate...

The following data set describes whether a given coordinate is on land owned by XX government. (x,y) | Class ------------------------ (1.5,6) | owned (2,5) | owned (3,4) | owned (

Rooted tree, Ask qu The figure below shows a rooted tree, 756_Find the hei...

Ask qu The figure below shows a rooted tree, 756_Find the height.png 1.1. Find the height/level of the tree as shown above?estion #Minimum 100 words accepted#

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