Sql Work

CIS 1513 Section 6 week5 Hmwk

Section 6 Normalization Homework

style find the correct vocabulary word from Section 6 lessons
1 foreign key| What does a UID become in a table|
2. simple UID| A UID that is a wholeness attrisolelye |
3.composite UID | A UID that is a combination of imputes |
4. Artificial UID| A UID that does not occur in the natural world but is created for identification purposes in a system |
5. UID of account| sometimes the UID is a combination of an attribute and a relationship.|
6. primary UID| A candidate UID is another attribute that can be utilise for a primary key. |
7. Entity attribute value| When in all the attributes in an entity are single- valued, that entity is said to be in:|
| This means that all attributes that are not part of the entitys UID should be strung-out on the whole UID.|
transitive verb form dependency| ___________exists when any attribute in an entity is dependent on another non-UID attribute.|


1. Match the instance of Unique identifier to the entity.
a. a.Simple UID
b. b.Composite UID
c. c.



Composite UID comprising an attribute and a relationship
d. d.Primary tombstone & Candidate Key

__b___ __d___ ___d__ __c___ __a__

1.Shelf size doesnt need to be there.

2.#fname, #Lname.

Identify the transitive dependency in the
framework below. State which attributes violate tertiary Normal Form.

Model????? What #STORE_ID
*NAME
*SUITE

*Store Speciality

PRODUCT
#PRODUCT_ID
oMODEL
o STORE_NAME
o STORE_ADDRESS

model? Not specified.If you want to get a full essay, parade it on our website: Orderessay



If you want to get a full essay, wisit our page: write my essay .