Skip to content

Assignment one#1

Open
beiwenwu wants to merge 3 commits intomainfrom
assignment-one
Open

Assignment one#1
beiwenwu wants to merge 3 commits intomainfrom
assignment-one

Conversation

@beiwenwu
Copy link
Copy Markdown
Owner

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

Create a logical-relationship diagram between customer table and customer purchases table
Complete coding questions in sql file
Complete section 4 in markdown file

What did you learn from the changes you have made?

I learned a lot from reading "When Databases Get to Define Family". I hadn’t previously thought about how database design can reinforce and has reinforced social hierarchies and inequalities around the world.

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

I was considering making the query output more comprehensive or cleaner. For example, in the second question of the aggregate section, I debated whether to show the actual amount of money that everyone spent at the market or to calculate it quietly within the HAVING statement. I think both approaches have their pros and cons, and the choice is very question- and context-driven.

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

The codes were relatively straightforward. I was able to compare the results from the output and manual calculation from the 'Browse Data' tab to verify the results.

How were these changes tested?

Run sql codes in DB Browser
Check changes using git status, commit the change, and then push the change

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

Checklist

  • [ y] I can confirm that my changes are working as intended

Copy link
Copy Markdown

@niyazmnazari niyazmnazari left a comment

Choose a reason for hiding this comment

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

Thank you for submitting Assignment 1. Everything looks correct. Great job!
Point: 30/30

P.S. Just a quick note, you don't need to use single quote when comparing integers. For example:
SELECT * FROM product WHERE product_id=4
Single quote used when we want to use string and character:
SELECT * FROM customer WHERE customer_first_name = 'Sofia'

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