Summarize the four steps involved in transforming an E-R diagram into normalized relations and then merging them into one consolidated set of relations
What will be an ideal response?
1. Represent entities. Each entity type in the E-R diagram becomes a relation. The identifier of the entity type becomes the primary key of the relation, and other attributes of the entity type become nonprimary key attributes of the relation. 2. Represent relationships. Each relationship in an E-R diagram must be represented in the relational database design. How we represent a relationship depends on its nature. 3. Normalize the relations. The relations created in steps 1 and 2 may have unnecessary redundancy. So we need to normalize these relations to make them well structured. 4. Merge the relations. So far in database design we have created various relations from both a bottom-up normalization of user views and from transforming one or more E-R diagrams into sets of relations. Across these different sets of relations, there may be redundant relations (two or more relations that describe the same entity type) that must be merged and renormalized to remove the redundancy.
You might also like to view...
The highest priority in emergency response plans should be to ______.
A. preserve physical assets B. protect the environment C. restore programs and normal operations D. protect human life
Websites where customers come to engage with other customers, the sponsoring firm, and others in the ecosystem to share ideas and collaborate on topics of mutual interest are called ________.
A. e-commerce sites B. customer communities C. omnichannel retailing sites D. product communities E. tying contracts
________ is the process of creating value from intellectual capital and sharing that knowledge with employees, managers, suppliers, customers, and others who need it.
A. Industrial information exchange B. Intellectual property protection C. Knowledge management D. Repository management E. Business process reengineering
Which of these résumé tips is most accurate?
A) Don't list awards and honors on a résumé; if you list them, you will appear to be bragging. B) Omit school and community activities from your résumé because they are unrelated to your work experience. C) Include your personal information (height, weight, and marital status) to give a potential employer a complete picture. D) Improve the visual impact of your résumé by placing your employment achievements and relevant job duties in an easy-to-read bulleted list.