Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help determining what normalization rules can be applied to my database. Attached is a copy of my database that I made in MySQL. Need

Need help determining what normalization rules can be applied to my database. Attached is a copy of my database that I made in MySQL.

  1. Need to apply the Normalization rules to my database design. And describe how 1NF, 2NF, and 3NF apply to your design/database schema.
beverage table.jpg


Customer Table.jpg


Orders Table.jpg


Pizza Table.jpg  
 

File Window SQL Query-DESKTOP-45500PK,Pizza Ordering System (DESKTOP-43500PK patte -creset SL Server Management Edit Query Project Tools New Quary Pizza Cedering System Execute 2 E = Object Explo Connect X SQLQuery.sql - DE..3500FK\patte 15 DESK OP-500...em-beverage Select From Severage DESKTOP-SOUPKPystem dhe Pata DES E DESKTOP 4050CPK (SQLS 15.0.2000.5 E Databases System Datab Ustabase Snapshots Pizze Ordering System Database Diagrams System Tables External Tables Graph Tables Views be Customar Extemal Resources Programmability Service Broker Storage Suity BoviD Devane vice Boardly dr Secunty Serve Obj Replication Polya Always On High Availability Management Integration Services Catalogs ver Age Agent XP) Event Profile

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To advise on how to apply normalization rules to your database we typically need to see the structure of the tables including column names data types ... blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Smith and Roberson Business Law

Authors: Richard A. Mann, Barry S. Roberts

15th Edition

1285141903, 1285141903, 9781285141909, 978-0538473637

More Books

Students also viewed these Databases questions

Question

licensure as a psychologist in the respective jurisdiction; and

Answered: 1 week ago

Question

Explain the concept of shear force and bending moment in beams.

Answered: 1 week ago