CREATE TABLE CUSTOMER ( CustomerID NUMBER PRIMARY KEY, Name VARCHAR2(20), Address VARCHAR2(20), PhoneNumber VARCHAR2(20), Email VARCHAR2(30), LoyaltyStatus VARCHAR2(20) ); CREATE TABLE ORDERS ( OrderID NUMBER PRIMARY KEY, OrderDate DATE, OrderStatus VARCHAR2(20), TotalCost NUMBER, CustomerID NUMBER, CONSTRAINT FK_ORDER_CUSTOMER FOREIGN KEY (CustomerID) REFERENCES CUSTOMER(CustomerID) ); CREATE TABLE PRODUCT ( ProductID NUMBER PRIMARY KEY, ProductName VARCHAR2(20), Description VARCHAR2(20), Price NUMBER, Category VARCHAR2(20) ); CREATE TABLE ORDERS_DETAILS ( OrderDetailID NUMBER PRIMARY KEY, OrderID NUMBER, ProductID NUMBER, ProductName VARCHAR2(20), Price NUMBER, Quantity NUMBER, Subtotal NUMBER, CONSTRAINT FK_ORDER_DETAILS_ORDER FOREIGN KEY (OrderID) REFERENCES ORDERS(OrderID), CONSTRAINT FK_ORDER_DETAILS_PRODUCT FOREIGN KEY (ProductID) REFERENCES PRODUCT(ProductID) ); CREATE TABLE STORE ( StoreID NUMBER PRIMARY KEY, StoreName VARCHAR2(20), Location VARCHAR2(20), HoursOfOperation VARCHAR2(20) ); CREATE TABLE INVENTORY ( ProductID NUMBER, StoreID NUMBER, QuantityOnHand NUMBER, ReorderPoint NUMBER, PRIMARY KEY (ProductID, StoreID), CONSTRAINT FK_INVENTORY_PRODUCT FOREIGN KEY (ProductID) REFERENCES PRODUCT(ProductID), CONSTRAINT FK_INVENTORY_STORE FOREIGN KEY (StoreID) REFERENCES STORE(StoreID) ); CREATE TABLE "TRANSACTION" ( TransactionID NUMBER PRIMARY KEY, TransactionDate DATE, TransactionType VARCHAR2(20), TotalAmount NUMBER, CustomerID NUMBER, CONSTRAINT FK_TRANSACTION_CUSTOMER FOREIGN KEY (CustomerID) REFERENCES CUSTOMER(CustomerID) ); CREATE TABLE TRANSACTION_DETAILS ( TransactionDetailID NUMBER PRIMARY KEY, TransactionID NUMBER, ProductID NUMBER, ProductName VARCHAR2(20), Price NUMBER, Quantity NUMBER, Subtotal NUMBER, CONSTRAINT FK_TRANSACTION_DETAILS_TRANSACTION FOREIGN KEY (TransactionID) REFERENCES "TRANSACTION"(TransactionID), CONSTRAINT FK_TRANSACTION_DETAILS_PRODUCT FOREIGN KEY (ProductID) REFERENCES PRODUCT(ProductID) ); CREATE TABLE EMPLOYEE ( EmployeeID NUMBER PRIMARY KEY, Name VARCHAR2(20), Address VARCHAR2(20), PhoneNumber VARCHAR2(20), Email VARCHAR2(30), Position VARCHAR2(20) ); CREATE TABLE SALARY ( EmployeeID NUMBER, StartDate DATE, SalaryAmount NUMBER, EndDate DATE, PRIMARY KEY (EmployeeID, StartDate), CONSTRAINT FK_SALARY_EMPLOYEE FOREIGN KEY (EmployeeID) REFERENCES EMPLOYEE(EmployeeID) ); CREATE TABLE SHIFT ( ShiftID NUMBER PRIMARY KEY, StartTime TIMESTAMP, EndTime TIMESTAMP, StoreID NUMBER, EmployeeID NUMBER, CONSTRAINT FK_SHIFT_EMPLOYEE FOREIGN KEY (EmployeeID) REFERENCES EMPLOYEE(EmployeeID), CONSTRAINT FK_SHIFT_STORE FOREIGN KEY (StoreID) REFERENCES STORE(StoreID) )； 加密Price和PhoneNumber给出代码

对于加密 Price 和 PhoneNumber，你可以使用 Oracle 数据库提供的加密函数来实现。例如，使用 DBMS_CRYPTO 包中的 AES256 加密算法，你可以执行以下 SQL 语句：

-- 创建加密密钥
DECLARE
  key_raw VARCHAR2(32) := 'mysecretkey1234567890123456789';
  key_blob BLOB;
BEGIN
  key_blob := utl_raw.cast_to_raw(key_raw);
  DBMS_CRYPTO.ENCRYPT_AES256(DBMS_CRYPTO.CBC_PKCS5, key_blob, NULL, key_blob);
  INSERT INTO MY_KEYS (ID, KEY_BLOB) VALUES (1, key_blob);
END;

-- 加密 Price 字段
UPDATE PRODUCT
SET Price = DBMS_CRYPTO.ENCRYPT(UTL_I18N.STRING_TO_RAW(Price, 'AL32UTF8'),
                                DBMS_CRYPTO.AES256_CBC,
                                MY_KEYS.KEY_BLOB,
                                UTL_RAW.CAST_TO_RAW('1234567890123456'));

-- 解密 Price 字段
SELECT DBMS_CRYPTO.DECRYPT(Price,
                           DBMS_CRYPTO.AES256_CBC,
                           MY_KEYS.KEY_BLOB,
                           UTL_RAW.CAST_TO_RAW('1234567890123456'))
FROM PRODUCT;

-- 加密 PhoneNumber 字段
UPDATE CUSTOMER
SET PhoneNumber = DBMS_CRYPTO.ENCRYPT(UTL_I18N.STRING_TO_RAW(PhoneNumber, 'AL32UTF8'),
                                       DBMS_CRYPTO.AES256_CBC,
                                       MY_KEYS.KEY_BLOB,
                                       UTL_RAW.CAST_TO_RAW('1234567890123456'));

-- 解密 PhoneNumber 字段
SELECT DBMS_CRYPTO.DECRYPT(PhoneNumber,
                           DBMS_CRYPTO.AES256_CBC,
                           MY_KEYS.KEY_BLOB,
                           UTL_RAW.CAST_TO_RAW('1234567890123456'))
FROM CUSTOMER;

需要注意的是，加密和解密操作都需要提供密钥。在上面的代码中，我使用了一个名为 MY_KEYS 的表来存储密钥，其中 ID 是主键，KEY_BLOB 是加密后的密钥。在实际使用中，你需要根据具体情况选择更加安全的密钥管理方式。