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

Compare cisc with risc cpus, Question 1 Define the following terms        ...

Question 1 Define the following terms                           1) Pipelining 2) Super Pipelining 3) Dynamic Execution 4) Multiprocessing 5) Multimedia Extensions Question 2

C, A palindrome is a string that reads the same from both the ends. Given a...

A palindrome is a string that reads the same from both the ends. Given a string S convert it to a palindrome by doing character replacement. Your task is to convert S to palindrome

History , when was the first computer made

when was the first computer made

Quiz for your learning activity, The development of your learning module is...

The development of your learning module is very time consuming, so it is recommended that you begin creating your learning module during this first week. Before you begin, download

Description of Instruction execution, When software is installed onto a mod...

When software is installed onto a modern day personal computer (most commonly from a CD-ROM, though other media or downloading from the internet is also common), code comprising th

Application packages, APPLICATION PACKAGES : There are two options. You ca...

APPLICATION PACKAGES : There are two options. You can either write your own program or buy an applications package, i.e. a proprietary program, 'off-the-shelf. The former option i

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

Describe the binary search algorithm, QUESTION 1 Describe the binary se...

QUESTION 1 Describe the binary search algorithm using an example of your own. QUESTION 2 (a) By showing all your workings, give a big-O estimate for f(x) = (x + 1)lo

What is an abstract data type, QUESTION (a) What is an abstract data ty...

QUESTION (a) What is an abstract data type? (b) Give two limitations of the array implementation of lists. (c) Give the major disadvantage of the dynamic implementation o

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