Lab 4: Building ER diagrams using an UML modeling tool
This lab designs ER diagrams in UML notation. The AutoER auto-grading software on PrairieLearn is used to design and mark your UML diagrams. It is also valuable to learn how to use commercial UML design software such as Astah. Note: Astah no longer has a free community version. Request a student license or use the 30-day trial. drawio is an online drawing tool that can also be used but it does not have as good support for database modeling in UML.
AutoER PrairieLearn link: https://plcanary.ok.ubc.ca/pl/course_instance/6/assessment/145
When using PrairieLearn, for each question please submit a screenshot showing your answer and the marking. Make sure the screenshot shows your name.
Construct a database design in UML for a stock market tracking database. Data types are not needed.
The database tracks companies, where a company has a name and is identified by its ticker symbol.
Each company participates in a particular industry. An industry has an identifying name and also a description.
Stock market analysts cover stocks and produce recommendations. Analysts are distinguished from each other by the name of their firm and their name. Analysts also have an accuracy rating that measures the accuracy of their recommendations.
Each recommendation is from a particular analyst on a certain company. A recommendation includes a predicted price in the next 12 months and a rating for the stock (buy, hold, sell).
Construct a database design in UML for a question databank. Data types are not needed.
A course is identified by its course number and has a course name and year.
A question is used in a course offering to test student knowledge. A question is identified by its questionId and also contains a questionName, questionText, and questionAnswer.
