Tollowing to SQL lite. CREATE TABLE 'Employee *EmployecID' stype "Employce_name' <type> *Address' type, PRIMARY KEY (EmployecID") ); CREATE TABLE Customer'( *CustomeriD' Ctype> "Customer_name' type> *Customer_mobile type, Customer_email' <type Customer_type "MembershipID" stype Shipping Address Stype> PRIMARY KEY (Customer D) ): CREATE TABLE 'Return ReturiD type ProductiDstype EmployeeID" <type> "CustomerID' stype> "Return_date' type PRIMARY KEY (ReturnID"), FOREIGN KEY (ProductID) REFERENCES Employee (EmployeeD). " FOREIGN KEY (Return") REFERENCES Customer Customer D) 3: CREATE TABLE 'Customers' "Customer stype Customer Name type Customer Mobile stype Customer Email' type Customer type "Membership type Shipping Address' types PRIMARY KEY CustomerID)) . CREATE TABLE 'Order Order' type Order DateTypo CastomerID Producttype PRIMARY KEY COrder FOREIGN KRY OrderID) REFERENCES Customer Customer Name
CREATE TABLE 'Product ( * ProductID' <type **Product_type type> "Product_price' <type> *Product_description type> PRIMARY KEY C ProductID) ); CREATE TABLE Store StorelD<type> "Address' type "Number_of_employees' <type, PRIMARY KEY (StorelD') ): CREATE TABLE 'Supplier SupplierID <type "Name' type Supplier_address' <type> PRIMARY KEY (SupplierID) ): CREATE TABLE Shipment ShipmentID type Store' type Supplier! <type Shipment_date' type PRIMARY KEY (ShipmentID). FOREIGN KEY (ShipmentID) REFERENCES Store (StoreID), FOREIGN KEY (ShipmentID) REFERENCES 'Supplier SupplierID) 3: CREATE TABLE 'Supplier Supplier type "Name' type Supplier_address' type PRIMARY KEY SupplierID) CREATE TABLE Store StoreID" type Address' type PRIMARY KEY StoreID) 3. CREATE TABLE 'Employce'( Employeeltype
*Employee_name' <type> "Address' <type> PRIMARY KEY (EmployeelD') ); CREATE TABLE Customers CustomerID <type> Customer_mobile' <type>, Customer_mobile <type> "Customer_email' <type, Shipping address <type, PRIMARY KEY (CustomerID") ); CREATE TABLE 'Payment "PaymentID <type> CustomerID' <type> *Amount' <type> *Payment_date' <type> PRIMARY KEY (PaymentID) ); CREATE TABLE Product ProductID' <type> *Product_type <types Product_price' <type, *Product_description" <type> PRIMARY KEY (ProductID) );
Tollowing to SQL lite. CREATE TABLE 'Employee *EmployecID' stype "Employce_name' *Address' type, PRIMARY KEY (Emp
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Tollowing to SQL lite. CREATE TABLE 'Employee *EmployecID' stype "Employce_name' *Address' type, PRIMARY KEY (Emp
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!