Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following description of something you may see in a database: Oak trees have become more and more sophisticated through evolution. This time, they

Consider the following description of something you may see in a database:

Oak trees have become more and more sophisticated through evolution. This time, they have taken a step forward. Each acorn generated by the oak tree comes with an identifying marker for scholars to help track them. One scholar has decided to make a database like this:

One table consists of the acornID and the Tree that produced it. Another table consists of a squirrelID, squirrelName, and an acornID (because this scholar has some squirrels who work for her to collect the acorns, but they do not get them all). She names all the squirrels, but she is forgetful. As such, it is possible that she may have repeated a name.

Describe the following types of keys in this database by defining them and then giving an example of them from the database:

a) Secondary Key

b) Primary Key (do so for each table)

c) Foreign Key (be sure to complete the description of this one as it has multiple pieces)

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

Visual Basic6 Database Programming

Authors: John W. Fronckowiak, David J. Helda

1st Edition

ISBN: 0764532545, 978-0764532542

More Books

Students also viewed these Databases questions