Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A government wants to build a database to record all the customs transactions at the border of its country so that it can effectively reduce

A government wants to build a database to 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)
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.
Data on the product include the Product ID, Product Name, Product Description, Unit Price, and Quantity.
Data on the customs agent include their agent ID, First Name, Middle Name, Last Name, Date of Birth, Gender, Date Hired, and Border Location.
Data on the Production Inspection includes Inspection ID, Date, and Tariff.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions