Part 2: Relational data model. Take a subset of the ideas from the conceptual model you constructed in Part 1 and design a simple relationship model similar to the ones we discussed in Module 2, Video 4Your model should have at least 5 tablesYou should include at least 20 attributes, or fields, in your model (20 total across all tables, not per table)Your model should be normalizedIdentify the primary key in each table, and state whether it is a natural or surrogate keyFor each relationship between tables, identify any foreign keys needed to define the relationshipFor each table, identify what type of system or systems you think the data might come from, like those we discussed in Module 1, Video 6.

The relational data model have the five entities and 24 attributes. pk - primary key fk - foreign…

Answered: Part 2: Relational data model. Take a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Part 2: Relational data model. Take a subset of the ideas from the conceptual model you constructed in Part 1 and design a simple relationship model similar to the ones we discussed in Module 2, Video 4

Your model should have at least 5 tables
You should include at least 20 attributes, or fields, in your model (20 total across all tables, not per table)
Your model should be normalized
Identify the primary key in each table, and state whether it is a natural or surrogate key
For each relationship between tables, identify any foreign keys needed to define the relationship
For each table, identify what type of system or systems you think the data might come from, like those we discussed in Module 1, Video 6.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions