Answered step by step
Verified Expert Solution
Question
1 Approved Answer
pls help!! need to put it into 1NF, 2NF AND 3NF!! also indicate primary keys. all i need is the table schema/structure no sql Question.
pls help!! need to put it into 1NF, 2NF AND 3NF!! also indicate primary keys. all i need is the table schema/structure no sql Question. Billing system of Sweet water Inc. A. Background Swcet water is a local supplier that will provide fresh water to 3 councies in PA. Before starting their services on fan 2023 , as an ingortant part of business, they need to secup their online portal to: - Let customers review their profile including: SSN, Name, Service Address, Phone mumber; - Let customers review their monthly usage (ton water) and bills. - Let customers pay their billt online. B. Sample data The manager provides us a sample data table. However, they were using Excel sheet in the past. C. Normalization Please read above given table carefully. 1. Please put above table to INF.just write table schema/structure ONLY, NO SQL or details neededi 2. Please write above table to 2NE, please indicate primary key(s). Again, just write table schema/structure ONLY here 3. Please write above table to 3NF, please indicate primary ley(s). Again, just write table schema/structure ONLY. No need of SQL. statement or detailed valisesi
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started