Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions