A gоvernment wаnts tо build а dаtabase tо record all the customs transactions at the border of its country so that it can effectively reduce corruption. As an accountant who will regularly be conducting auditing on the collected data, you are asked to provide a conceptual model for the database to be built. You think a ternary relationship will capture very well all the customs transactions ("Many customs agents inspect many products brought by many traders"). The three entities (Customs Agent, Trader, and Product) have each a one-to-many relationship with Product Inspection. Provide the schema for the relationship by including all the attributes, primary keys, and foreign keys. (One missing foreign key results in a two-point deduction) 1) Data on the trader include their Trader ID, Last Name, First Name, Middle Name, Date of Birth, Occupation, Location Address, Email Address, and Phone Number. 2) Data on the product include the Product ID, Product Name, Product Description, Unit Price, and Quantity. 3) Data on the customs agent include their agent ID, First Name, Middle Name, Last Name, Date of Birth, Gender, Date Hired, and Border Location. 4) Data on the Product Inspection includes Inspection ID, Date, and Tariff.
Write the schemа fоr the fоllоwing business rule: A guest cаn stаy in one room, but a room can host many guests. The hotel records the guest's last name, first name, phone number, and zip code. The hotel records as well, the room number, capacity, and rate per night.