A *:* relationship between Purchase Goods and Goods (Inventory) requires a newly
ID: 3753204 • Letter: A
Question
A *:* relationship between Purchase Goods and Goods (Inventory) requires a newly created table in the database. How does Access want the newly created table's primary key to be built in design view? 1. Purchase goods primary key and Goods primary key are listed on separate lines in design view. Those two lines are each identified with a key symbol in design view. 2. Access will create the new ID for us and assign the primary key. 3. Purchase goods primary key and Goods primary key are listed on the same line in design view. That one line is identified with a key symbol. 4. Purchase goods primary key and Goods primary key and Purchase goods-Goods primary key are listed on three separate lines in design view. Those three lines are each identified with a key symbol in design view.
Explanation / Answer
Anwer - Option 1
Description :--
The newly created table between Purchase Goods and Goods(Inventory) will be a derived table and will have a composite primary key which will be made from primary keys of Purchase Goods and Goods(Inventory) which will be foreign keys in derived table and will be used to create the composite primary key and that in Microsoft Access will created by selecting both(Purchase Goods and Goods) primary keys and clicking it on the Primary Key button from the tool bar, so from the option given by you option 1 will be the appropriate answer
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.