Skip to content

Latest commit

 

History

History
52 lines (37 loc) · 2.85 KB

design_a_logical_model.md

File metadata and controls

52 lines (37 loc) · 2.85 KB
Raw

Assignment 1: Design a Logical Model

Question 1

Create a logical model for a small bookstore. 📚

At the minimum it should have employee, order, sales, customer, and book entities (tables). Determine sensible column and table design based on what you know about these concepts. Keep it simple, but work out sensible relationships to keep tables reasonably sized. Include a date table. There are several tools online you can use, I'd recommend Draw.io or LucidChart.

Question 2

We want to create employee shifts, splitting up the day into morning and evening. Add this to the ERD.

Question 3

The store wants to keep customer addresses. Propose two architectures for the CUSTOMER_ADDRESS table, one that will retain changes, and another that will overwrite. Which is type 1, which is type 2?

Hint, search type 1 vs type 2 slowly changing dimensions.

Bonus: Are there privacy implications to this, why or why not?

Your answer...

Question 4

Review the AdventureWorks Schema here

Highlight at least two differences between it and your ERD. Would you change anything in yours?

Your answer...

Criteria

Assignment Rubric

Submission Information

🚨 Please review our Assignment Submission Guide 🚨 for detailed instructions on how to format, branch, and submit your work. Following these guidelines is crucial for your submissions to be evaluated correctly.

Submission Parameters:

  • Submission Due Date: September 28, 2024
  • The branch name for your repo should be: model-design
  • What to submit for this assignment:
    • This markdown (design_a_logical_model.md) should be populated.
    • Two Entity-Relationship Diagrams (preferably in a pdf, jpeg, png format).
  • What the pull request link should look like for this assignment: https://github.com/<your_github_username>/sql/pull/<pr_id>
    • Open a private window in your browser. Copy and paste the link to your pull request into the address bar. Make sure you can see your pull request properly. This helps the technical facilitator and learning support staff review your submission easily.

Checklist:

  • Create a branch called model-design.
  • Ensure that the repository is public.
  • Review the PR description guidelines and adhere to them.
  • Verify that the link is accessible in a private browser window.

If you encounter any difficulties or have questions, please don't hesitate to reach out to our team via our Slack at #cohort-4-help. Our Technical Facilitators and Learning Support staff are here to help you navigate any challenges.