Database Management for Business Analytics
Homework
Pick up any one of the short cases (except Investco Scout) from the Database Design Exercises document
posted in Module 4.
1) Create an ERD diagram for it using ERDPlus.
2) Convert it to Relational Schema diagram. See screenshots below.
3) Now edit the Schema. Set attribute types and sizes in the Schema diagram. Use your own
judgement what type and size to use for each attribute. Hint: char for IDs, varchar for any other
text, int for whole numbers, date for dates, float for decimal point numbers.
4) Generate SQL for this schema.
5) Copy this SQL code and paste it in a Word document and submit it back on Canvas.
