Skip to content

GP2: Conceptual Design

Due: Monday, Sep 22nd

EER Diagram for MedX Example
Image source: Sep 11th Slides

Instructions

For this assignment, you will create the initial design of your group project database. Your design must use EER Notation, in particular the compact entity style with crow's foot relationships, and be drawn using draw.io. One group member should create and share the diagram with other group members. Real-time collaboration is available if you store your diagram file in Microsoft OneDrive or in Google Drive (recommended).

As a team, decide who will be responsible for which features of your proposed project. Then draw the entities and relationships needed to implement those features. We anticipate most diagrams will have about a dozen "shapes" (entities and relationships). Each student must contribute at least 3 "shapes" on the diagram. You are welcome to design more entities and relationships.

Include notes on the diagram to explain anything that is not straightforward. Also document any assumptions that you're making about the data at this point. Arrange the diagram neatly and organize the layout to flow well.

Submission

The following files are required for GP2 in your GitHub repository:

  • database/EER.drawio – source file of the diagram
  • database/EER.pdf – a PDF export of the diagram

Make sure the PDF looks good; that's the file the professors will print to evaluate your work. Take time to arrange the diagram either to fit all on one page or to span page breaks in an elegant way.