Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Should Mr . Yoshimura adopt a database for managing his data? Advise him on what a database could do for his organization. Make sure to
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 or 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
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