Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q: Should Mr . Yoshimura adopt a database for managing his data? Advise him on what a database could do for his organization. Make sure

Q: Should Mr. Yoshimura adopt a database for managing his data? Advise him on what a database could do for his organization. Make sure to discuss the reasons for and characteristics of storing this information in a relational database (such as referential integrity and how many primary and foreign keys would be in such a database). Explain in detail.
You may use any format (such as paragraphs, bullet points, etc.) to answer this question.Read the following prompt. Apply your knowledge of the components of databases as well as any other Chapter 14 or 7 topics to support your conclusion.
Hiroshi Yoshimura is chair of the Panda Preservation Project, which maintains a database of all panda bears across the globe. The database design includes a relational database comprising two tables. The first table stores the name, birth date, and other characteristics of panda bear parents that have been registered. In this table, each panda bear parent is uniquely identified by a registration number.The second table stores the name, birth date, and other characteristics of panda bear kids that have been registered. In this table, each panda bear kid is uniquely identified by a registration number. This second table also includes the registration numbers of each panda bear kids parents. The panda bear kids in the second table are linked to their parents in the first table by means of the registration numbers of both parents.Physically, the database is housed in an information system located on a wildlife preserve. As such, Hiroshi has concerns about potential physical threats to the system, such as storm or water damage, or power failure. Hiroshi also worries about the correctness of the information being entered into the database, as it is entered by many PPP workers and volunteers across different sites, often remotely, without any centralized, consistent training on the system.

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