What would you recommend as primary key for this relation

Assignment Help Computer Engineering

Reference no: EM133424106

Question: The following relation is an extract from a restaurant point-of-sale (POS) system. The system assigns a globally unique id (GUID) to every transaction processed. CheckID comes from the pre-printed check number on the ticket used by the server for the order; these pre-printed tickets are guaranteed to be unique within the restaurant. RegisterID is which register was used for checkout and the date and time of the checkout - to the minute - are recorded in CheckoutDT; assume no two checkouts can occur at the same register in the same minute. PayType and PayTotal are, respectively, how the check was paid and what the total payment was; assume there is no splitting of a check among multiple payments.

When answering the questions below use the format [attribute, attribute, ..., attribute] to identify keys.

1. How many keys in general (including the empty or null key) are there in this relation?

2. Identity two multi-keys for this relation.

3. Identify two super keys which are not also candidate keys for this relation. Identify all candidate keys for this relation.

4. What would you recommend as primary key for this relation? Why?

5. If splitting or multiple payments were to be allowed for a ticket total (e.g., suppose the second payment above consisted of a 35.10 Credit payment and a 30.12 Cash payment), what changes would you suggest to the relation above?

Reference no: EM133424106

Questions Cloud

What is a composite function and how are composite functions : what is a composite Function? How are composite functions solved? Give examples.

Advice norman about the difference between criminal : Advice Norman about the difference between criminal proceedings and civil proceedings. Substantiate your answer with practical examples.

What psychological theories would be relevant : How would I address this recommendation from OFSTED? What psychological theories would be relevant?

Transcatheter arotic valve replacement : Can somone please help me explain these three things for transcatheter Arotic Valve Replacement (TAVR).

What would you recommend as primary key for this relation : How many keys in general (including the empty or null key) are there in this relation and Identity two multi-keys for this relation

How can you describe the threat level posed from hickory : how can you describe the threat level posed from Hickory Divine's suppliers? Is it high? Is it low? Why? Provide an explanation by using the logic

How would one go about finding information : How would one go about finding information for different roles in cyber security without reaching out to individuals? Find five professionals

How to use rebts cognitive restructuring techniques humor : How to use REBT's cognitive restructuring techniques humor, irony, reframing, roly-play to help Patrick address his mother reprimanded him for poor performance.

Effective functioning of interprofessional team : Open and clear communication is critical for the effective functioning of the interprofessional team and the delivery of safe patient care.

User Account

All Pages