BILLING REPORT Invoice ID App name Amount Due Date of Purchase Paid? CustomerID Customer Name Customer Address
Question:
BILLING REPORT
Invoice ID | App name | Amount Due | Date of Purchase | Paid? | CustomerID | Customer Name | Customer Address | DOB |
14000 | Groupon | 0.99 | 10/13/2021 | Y | 101 | Bilbo Baggins | 123 OverHill Ave | 3/5/1910 |
14000 | Groupon | 0.99 | 8/15/2020 | Y | 102 | Frodo Baggins | 456 UnderHill St | ######## |
14001 | Spotify | 0 | 9/3/2007 | N | 103 | Harry Potter | 864 Hogwarts St | ######## |
14010 | Candy Crush | 1.99 | 5/4/2016 | Y | 103 | Harry Potter | 864 Hogwarts St | ######## |
15000 | Bird Tracker | 5.99 | 11/23/2017 | Y | 103 | Harry Potter | 864 Hogwarts St | ######## |
14010 | Candy Crush | 1.99 | 12/25/2019 | N | 104 | Mickey Mouse | 757 Clubhouse Ave. | 1/1/1964 |
15000 | Bird Tracker | 5.99 | 8/1/2018 | N | 102 | Frodo Baggins | 456 UnderHill St | ######## |
14001 | Spotify | 0 | 7/5/2021 | Y | 105 | Tommy Pickles | 655 Rugrat Blvd | ######## |
The student billing report assists the registration and treasurers offices to determine how much a student currently owes the university, and whether or not a students bills have been paid.
- What normal form is this report currently in? Explain.
-
- Draw this table out into a relational model and identify the primary key(s) and the partial dependencies that is, are there any fields that are dependent on part, but not all of the primary key. Identify any transitive dependencies that is, are there any fields dependent on other fields that are not part of the key
- Now break your tables out into 3NF so that all of your dependencies have been resolved. Using Lucidchart or Erwin, model your relational diagram into an ERD