COMPSCI 122A Study Guide - Quiz Guide: Decimal Mark, Foreign Key, Hatchback

171 views3 pages

Document Summary

Cs 122a: introduction to data management spring 2020. Homework 2: e/r and relational translation (100 points) Id and your name and must be submitted online (e. g. , See the table below for the hw 2 submission opportunities. Note that after 11 pm on saturday the 18th no further hw 2 submissions will be accepted. (we will be releasing the solution at that time. ) Please strive to get all your work in on time! If possible, try to save the one dropped assignment for the end of the term when you are most likely to want/need it. You have successfully designed an e-r diagram for shopalot. Now, to set up a real database, you must design a relational schema to represent the objects described in the e-r diagram that you created. Specifically, you will need to design an appropriate collection of tables and create a sql ddl statement for each table.