Explanation The steps that must be repeated for each user view to present the information-level design. Represent the user view in terms of tables. Normalize the tables. Identify all the keys in the tables. Merge the result of step 1 to 3 into cumulative design. Represent the user view in terms of tables For each type of entity, a separate table must be created. The primary key for each table must be determined. The relationship between the entities can be one-to-many, many-to-many and one-to-one. Normalize the tables Normalization is a database design approach of expressing tables to reduce the redundancy (repetition) and dependency of data...

To list the steps and summarize the kinds of activities that must take place at each step for information-level design method.

Concepts of Database Management

9th Edition

ISBN: 9781337093422

Author: Joy L. Starks, Philip J. Pratt, Mary Z. Last

Publisher: Cengage Learning

See similar textbooks

Question

Chapter 6, Problem 4RQ

To determine

To list the steps and summarize the kinds of activities that must take place at each step for information-level design method.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Chapter 6, Problem 3RQ

Chapter 6, Problem 5RQ

Knowledge Booster

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi...
Computer Engineering
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:PEARSON
Computer Organization and Design MIPS Edition, Fi...
Computer Engineering
ISBN:9780124077263
Author:David A. Patterson, John L. Hennessy
Publisher:Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:9781337569330
Author:Jill West, Tamara Dean, Jean Andrews
Publisher:Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:9781337093422
Author:Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:9780133750423
Author:VENIT, Stewart
Publisher:Pearson Education
Sc Business Data Communications and Networking, T...
Computer Engineering
ISBN:9781119368830
Author:FITZGERALD
Publisher:WILEY