CHAPTER 3: ENTITY-RELATIONSHIP (E-R) MODEL & NORMALIZATION

This puzzle will test understanding regarding the concept in entity relationship diagram(ERD) and normalization in database

1	2
			3
		4

5
6

					7
		8

				9

		10

Across

1. A normal form in which every determinant is a key is ___________ .

6. Entities can be associated with one another by a __________________

8. Properties that describe the characteristics of entities are called _____________

9. A function that has no partial function dependencies is in _____________ normal from.

10. The attribute AGE is calculated from DATE_OF_BIRTH.The attribute is called ______________ attribute

Down

2. The purpose ____________ is to reduce data redundancy and to eliminate anomalies

3. An attribute that can be broken into components is refers to ____________ attribute.

4. PhoneNo is considered as one of a ______________ attribute.

5. Third normal form is based on the concept of ______________ dependency.

7. A _____________ relationship that involves three entities.

Use the "Printable HTML" button to get a clean page, in either HTML or PDF, that you can use your browser's print button to print. This page won't have buttons or ads, just your puzzle. The PDF format allows the web site to know how large a printer page is, and the fonts are scaled to fill the page. The PDF takes awhile to generate. Don't panic!