Answered step by step
Verified Expert Solution
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 onetomany 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 twopoint 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started