Skip to content

Homework Submission#1

Open
CharlesColaco wants to merge 6 commits intomainfrom
Homeworks
Open

Homework Submission#1
CharlesColaco wants to merge 6 commits intomainfrom
Homeworks

Conversation

@CharlesColaco
Copy link
Copy Markdown
Owner

What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

Added ER Diagram Image for Homework1 submission

What did you learn from the changes you have made?

Learnt about ER diagrams

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?

How were these changes tested?

Image Diagram was created, no testing was require

A reference to a related issue in your repository (if applicable)

Checklist

  • I can confirm that my changes are working as intended

@CharlesColaco CharlesColaco changed the title Homework 1 Submission Homework Submission Sep 13, 2024
@CharlesColaco
Copy link
Copy Markdown
Owner Author

What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

Added SQL Queries for HomeWork 2 submission in this commit d600576

What did you learn from the changes you have made?

SQL Queries

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?

How were these changes tested?

Queries were tested in DB Browser for SQLite

A reference to a related issue in your repository (if applicable)

Checklist

  • I can confirm that my changes are working as intended

Copy link
Copy Markdown

@amanda-ng518 amanda-ng518 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

HW1: 8/8

Copy link
Copy Markdown

@amanda-ng518 amanda-ng518 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

HW2: 8/8

@CharlesColaco
Copy link
Copy Markdown
Owner Author

What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

Added SQL Queries for HomeWork 3 submission in this commit c3de981

What did you learn from the changes you have made?

SQL Queries, Aggregates, Temporary Tables, Strftime

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?

How were these changes tested?

Queries were tested in DB Browser for SQLite

A reference to a related issue in your repository (if applicable)

Checklist

  • I can confirm that my changes are working as intended

Copy link
Copy Markdown

@amanda-ng518 amanda-ng518 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

HW3: 8/8

@CharlesColaco
Copy link
Copy Markdown
Owner Author

What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

Added SQL Queries for HomeWork 4 submission in this commit 97dfc2b

What did you learn from the changes you have made?

SQL Queries, coalesce, Windowed Functions, String manipulations, UNION

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?

How were these changes tested?

Queries were tested in DB Browser for SQLite

A reference to a related issue in your repository (if applicable)

Checklist

  • I can confirm that my changes are working as intended

@CharlesColaco
Copy link
Copy Markdown
Owner Author

CharlesColaco commented Sep 22, 2024

What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

Added SQL Queries for HomeWork 5 submission in this commit d41769b

What did you learn from the changes you have made?

SQL Queries, cross join, create table, Insert, Delete, Update

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?

How were these changes tested?

Queries were tested in DB Browser for SQLite

A reference to a related issue in your repository (if applicable)

Checklist

  • I can confirm that my changes are working as intended

@CharlesColaco
Copy link
Copy Markdown
Owner Author

What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

Modified Homework_6.md for HomeWork 6 submission in this commit b9915dd

What did you learn from the changes you have made?

Learnt about considerations for Ethics, addressing concerns about inequality, data privacy

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?

How were these changes tested?

Testing not Required

A reference to a related issue in your repository (if applicable)

Checklist

  • I can confirm that my changes are working as intended

Copy link
Copy Markdown

@amanda-ng518 amanda-ng518 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

HW4: 8/8

Copy link
Copy Markdown

@amanda-ng518 amanda-ng518 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

HW6: 8/8

Copy link
Copy Markdown

@amanda-ng518 amanda-ng518 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

HW5: 8/8

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants