Ask a Question
  
  
  
Top Posters
Since Sunday
7
6
6
5
5
5
4
4
4
4
4
4
New Topic  
wrote...
Posts: 44
A week ago
Describe the steps in assessing table structure when you are given a set of tables and asked to construct a new database to store the existing data.
Source  Download Study Guide
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 5 times
3 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 27
Rep: 5 0
A week ago
Sign in or Sign up in seconds to unlock everything on Biology Forums.
First, you should count the number of rows in the tables and determine the type of data stored in each column. Second, you should analyze the existing data values and work with users to determine (1) multivalued dependencies, (2) functional dependencies, (3) candidate keys, (4) primary keys and (5) foreign keys. Finally, you should check the validity of the possible referential integrity constraints.
1
Related Topics
wrote...
A week ago
TY
wrote...
A week ago
Welcome Slight Smile
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  67 People Browsing
 203 Signed Up Today
Related Images
 951
 644
 70
Your Opinion
What percentage of nature vs. nurture dictates human intelligence?
Votes: 61