1. ( For the Cities database, discuss one problem with either the correctness of the data or what can be easily done with the data that might occur if each of the following changes were made: • The state attribute of the City table was allowed to be null • The County table was merged into the State table by removing the County table and including a counties column in the State table with the names of the counties, plus a websites column in the State table with the websites for each county. The county column of the City table would just be the name of the county.
Please write in plain text format. Please dont copy the one that is already done!
1. ( For the Cities
correctness of the data or what can be easily done with the data that might
occur if each of the following changes were made:
• The state attribute of the City table was allowed to be null
• The County table was merged into the State table by removing the County
table and including a counties column in the State table with the names of
the counties, plus a websites column in the State table with the websites
for each county. The county column of the City table would just be the
name of the county.
2. Normalization
The total set of five attributes is: {name, state, district, bill, vote}. This is for
votes of members of the House of Representatives on the bills that come up for a
vote. The functional dependencies that hold are:
◦ {name} → {state, district}
◦ {billNum, name} → {vote}
• Now convert the above into Third Normal Form. Indicate all primary keys
and foreign keys
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images