For Exercise 2
1.What data redundancies do you detect?
2.What modification problem (i.e., Deletion, Insertion, and Update problem) it has?
3.Identify different themes (topics) in the file
For Exercise 3
Use the table below and summarize in a page what are possible data elements you can think of and possible meta data definitions
for example
Drivers name could comprise
Data Elements MetaData
FirstName AlphaNumeric Min 3 Max 10
LastName AlphaNumeric Min 3 Max 10
MiddleName AlphaNumeric Min 3 Max 10
Facts (from the Driver License Bureau’s database) |
Data |
Metadata |
a. Driver’s name, address, and birthdate |
||
b. Driver name is a 30-character field |
||
c. A photo image of the driver |
||
d. An image of the driver’s fingerprint. |
||
e. The make and serial number of the scanning device for scanning the fingerprint |
||
f. The resolution (in megapixels) of the camera that was used to photograph the driver |
||
g. The fact that the driver’s birthdate must precede today’s date by at least 16 years. |
0 comments