Answer the following questions:1.Describe the proper naming guidelines for entities and attributes. 2.Provide a broad description of the goals of normalization 3.An attribute will do one of three...

1 answer below »
Answer the following questions:1.Describe the proper naming guidelines for entities and attributes.
2.Provide a broad description of the goals of normalization
3.An attribute will do one of three things. Name those things and describe them.
4.Is theLastNameattribute a good choice to be the primary key for a CUSTOMER entity? Please elaborate why or why not?
5.How is a relationship specified between two entities?
Answered Same DayFeb 17, 2021

Answer To: Answer the following questions:1.Describe the proper naming guidelines for entities and attributes....

Deepti answered on Feb 17 2021
135 Votes
Answer 1:
· Unique names must be used for each entity
· Names are not case-sensitive
· Names are
not allowed to have special characters.
· Attributes in different relations can use the same name. Such attributes in a query should be qualified with the relation name to prevent ambiguity. Declare alternative relation name called aliases if the same relation is queried twice.
· Multiple references are allowed to the same entity. Aliases can be used to represent different references to that entity.
Answer 2:
· To mitigate or eliminate (if possible) redundancy in data
· Eliminate inconsistent data
· Efficient utilization of storage space
· Easy...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here