Assignment 4: Normalization
Step 1. Start by watching this short video.
You may also find this website useful.
https://www.freecodecamp.org/news/database-normalization-1nf-2nf-3nf-table-examples/
Use Lucid Chart for both parts of this assignment.
Part 1. Normalize the IT Department database you created in Assignment 2.
Part 2. Create and normalize a new financial database based on the excel spreadsheet below. (Hint: there are at least 4 tables)
The definitions or functionality of each column is listed here:
- Date – this the date of the transaction
- Account – this is the account where the transaction took place (ie. Wells Fargo, TIAA)
- Asset Class – this is the type of asset the ticker is. It could be a stock, bond, crypto…
- Ticker – this is what you purchase, like MFST is Microsoft stock.
- Transaction Type – this defines the type of transaction, it could be a buy, sell, fee or dividend. There may be other transaction types, but those are the most common.
- Price – this is the price paid when purchased the ticker.
- Shares – this is the quantity of shares purchased.
- Total Costs – this is price x shares
- Stock Price – I defined this as the current stock price, what it is right now. This price changes, but technically we can update this price with a simple update
- Current Value – you may not need this in the database since you can have the application you build calculate it off the other fields.
- Gain / Loss – just like current value, this could be a calculated field that you may not need to store in the database.
Turn in. Take screenshots of both normalized databases and submit them to GeorgiaView Assignment 4.