what is the DDL that has 7 tables in 3rd normal form?

This project is about creating a database system for a store named PIZZACO ,owned by John, which offers pizza and tacos as primary food options to customers but also other foods and beverages in only delivery format. We are creating this project from the perspective of the owner, John. The main focus of the database system is to manage customer orders and stock control. The purpose of this project is to create a centralized and secure database system and will help the store to make informed decisions about stock ordering and replenishment, which will ultimately result in cost savings and increased profitability. Currently, the store is managing all its operations manually on paper without the aid of any database system.  
 

This project is needed to improve the store's efficiency and productivity by reducing manual efforts and maintaining accurate records of customer orders and stock levels. It will also help the store to calculate specific expressions like total order, average income per day without employee's salary, manage inventory better, and ensure that there is no shortage of stock. It will store all customer orders, and stock levels, making it easier for the store to access and manage data. The database will also help the store to predict when new stock needs to be ordered by tracking stock levels for suppliers. The store staff, including the owner, managers, and employees, will utilize this project. This project will help them to manage their daily operations more efficiently and accurately. The customers will also indirectly benefit from this project as it will ensure that the store always has enough stock to fulfill their orders. Types of reports, forms, and queries: total of cost per day (excluding employees salary), total of sales per day, number of customers, inventory reports, customer order forms, purchase orders, number of item sold on a specific day or the stock level of a particular item

Answer rating: 100% (QA)

Answer 1 CREATE TABLE Customers CustomerID INT PRIMARY KEY FirstName VARCHAR50 LastName VARCHAR50 P... View the full answer