Relational Constructs   «Prev  Next»

Rules for Database Rows - Exercise

Translate entities and attributes

Objective:Translate entities and attributes into tables with column headings.

Exercise scoring

This exercise is worth a total of two points. This exercise is auto-scored. When you have answered the question below, click the Submit button to receive credit for having completed the exercise and view a results page.

Background and Overview

In this exercise, you will create tables with column headings based on the entities and attributes in the ER diagram for the course project. This is the beginning of a database design that tracks orders placed with Stories on CDs.

Instructions

Below is an illustration of the ER diagram for the Stories on CD case study. Create tables with column headings for the Customer, Order, CD, Distributor, and Line Item entities on the diagram.

Stories on CD ER diagram
Stories on CD ER diagram

Submitting your exercise

This exercise is auto-scored, which means there is nothing to submit.
When you have answered the question, click the Submit button to receive credit for completing the exercise and view a results page.