Your question:

need help with this question

Assignment Help Answers with Step-by-Step Explanation:

1. Customer

- CustomerID (Primary Key)

2. Billing

- BillingID (Primary Key)

- ItemID (Primary Key)

- Description

- DriverID (Primary Key)

- Name

- DeliveryID (Primary Key)

- DriverID (Foreign Key)

- StaffID (Primary Key)

- Name

- VehicleID (Primary Key)

- Model

1. A customer can have multiple billing records, but each billing record is associated with one customer. This is a one-to-many relationship.

2. Each delivery item is associated with one customer. This is a one-to-one relationship.

Now, to ensure a proper design for importing data from flat files, you should define the data types, constraints (e.g., primary and foreign keys), and indexes in your Oracle database. Also, consider how data from the flat files will map to these tables in your database. Make sure to set appropriate relationships and enforce referential integrity through foreign keys.

After designing the database schema, you can use SQL or a data migration tool to import the data from the flat files into the corresponding database tables. Data validation and cleansing may be required during the import process to ensure data accuracy and consistency.