Skip to content
Open
Show file tree
Hide file tree
Changes from all commits
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
13 changes: 11 additions & 2 deletions 02_activities/assignments/assignment_rubric.md
Original file line number Diff line number Diff line change
Expand Up @@ -21,10 +21,12 @@
- **Date Table**:
- Must exist with typical columns.
- Must have correct relationships with other relevant tables indicated.

<br><br> **Solution: <br>
![alt text](image-1.png)
## Question 2
- Employee Shift Table exists, and we can discern morning/evening shifts from its design**

<br><br> **Solution: <br>
![alt text](image-2.png)
## Question 3:
- **Two distinct architectures are proposed**
- **One design for Customer Addresses table would retain changes**
Expand All @@ -33,11 +35,18 @@
- Both Correct (Complete)
- One Wrong (Incomplete)
- Both Wrong (Incomplete)
<br><br> **Solution: <br>
![alt text](image-3.png)

## Question 4:
- **AdventureWorks ERD has been examined**
- **Two interesting differences between participant ERDs and AdventureWorks ERDs highlighted**
- **Student reflection on differences between the ERDs**
<br><br> **Solution: <br>

1.Participant ERDs are more specialized (tailored for specific applications or projects), while AdventureWorks ERDs provide a comprehensive overview suitable for a variety of business scenarios. <br>
2. Participant-ERD vary in complexity depending on the project's needs While adventureWorks generally more complex (gives more features & capabilities) <br>


## Criteria

Expand Down
Binary file added 02_activities/assignments/image-1.png
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Binary file added 02_activities/assignments/image-2.png
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Binary file added 02_activities/assignments/image-3.png
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Binary file added 02_activities/assignments/image.png
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
6 changes: 6 additions & 0 deletions 02_activities/homework/homework_6.md
Original file line number Diff line number Diff line change
Expand Up @@ -6,3 +6,9 @@
<br>

**Write**: Reflect on your previous work and how you would adjust to include ethics and inequity components. Total length should be a few paragraphs, no more than one page.
<br> <br> **Solution** <br>
In project management there is a larg part about "Risk planning and decision making" , <br>
from now on I will re-phrase the statement to be " Risk planning & ethical decision making" , <br>
in other words I will discuss in more details and on a wider scale the ethical implications of any decision <br>
and will try to accomodate more diverse team members in the brainstorm sessions.

Binary file modified 05_src/sql/farmersmarket.db
Binary file not shown.
Binary file added 05_src/sql/farmersmarket.db-journal
Binary file not shown.