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

Methods of working with files, There are two methods to work with files, th...

There are two methods to work with files, the first one is through file control blocks or "FCB" and the second one is through communication channels, also identified as "handles".

Breadth first search - artificial intelligence, Breadth First Search - arti...

Breadth First Search - artificial intelligence: Given a set of operators o1, ..., on in a breadth primary search, every time a new state s is reached, an action for every  oper

Instruction pipeline, How branching takes place in Instruction pipeline. Ex...

How branching takes place in Instruction pipeline. Explain with suitable examples.

Generations of computers, Ask question #Minimum assignment on generations o...

Ask question #Minimum assignment on generations of computers 100 words accepted#

Types of pc, TYPES OF PC:  In general,  basic function of all the comp...

TYPES OF PC:  In general,  basic function of all the computers is same i.e. Computers accept data as input, perform operations on these data and generates the desired output t

Assembly, can you help me to do my assembly program homework

can you help me to do my assembly program homework

Coaxial cables, Coaxial Cables: Another metallic transmission medium w...

Coaxial Cables: Another metallic transmission medium which offers a large bandwidth, is the coaxial cable. Such cables consist of an outer protective shell made of copper tube

Unix, How do I change file permissions? Every time I execute chmod commands...

How do I change file permissions? Every time I execute chmod commands it tells me permission denied.

Loading instructions, They are particular register instructions. They are u...

They are particular register instructions. They are used to load bytes or sequences of bytes onto a register. LODS (LODSB) (LODSW) LAHF LDS LEA LES LODS (LODSB) (LODSW) INSTRUCTION

REMOTE DESKTOP, I WANT TO CONNECT A PC WIYH MY PC THROUGH REMOTE DESKTOP. W...

I WANT TO CONNECT A PC WIYH MY PC THROUGH REMOTE DESKTOP. WHAT I DO TELL ME PLEASE

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