Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Accounting information system Qussnou 1 (1o Marks] a. Identify three {3} advantages relational databases provide over other database models. [3 Marks} b. Explain the relationship

Accounting information system

image text in transcribed
Qussnou 1 (1o Marks] a. Identify three {3} advantages relational databases provide over other database models. [3 Marks} b. Explain the relationship between a primary key and a foreign key in a relational database. [3 Marks] c. Wendy's Ice Cream Shop has contracted 1you to Implement a relational database system to help them keep track oftheir Sales. Design at least two {2} tables that would be needed to capture data for a sales transaction to allow Wendy's to review monthly sales reports. Each table should Include a primary key, two {2} non-key attributes and foreign keys as necessary. Create data values for two {2] records within each table. [4 marks}

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

Fundamentals Of Advanced Accounting

Authors: Joe Hoyle

4th Edition

78136636, 978-0078136634

More Books

Students also viewed these Accounting questions