1. Select any Invoice from a company/service etc. You can search for it online or use one...
Question:
1. Select any Invoice from a company/service etc. You can search for it online or use one of your company or service providers (handyman, pool service etc). The invoice needs to have at least 4 different fields and at least 3 lines of item/products data.
2. Attach the .jpeg or screenshot of the Invoice.
3. Prepare a database named ‘Invoice’ in ‘raw form/0NF’ and add all the fields as columns and fill up the table with given data (line items, name, etc.).
4. Perform the Normalization process of 1NF, 2NF, 3NF and normalize the Invoice table. This might lead to the creation of other tables too. Normalize them too using the same process. Show all your steps in an organized way.
5. Once the tables/entities have been identified → Draw the E-R model/(ERD) using Visio 2013 and paste a ‘screen shot’ of the ERD. Mark the Primary Key (PK) (which can also be a composite key - so you mark two primary keys) and Foreign (FK) if applicable.