acct

Discuss in detail: (a) the reasons for and characteristics of storing this information in a relational database (including talking about referential integrity and how many primary and foreign keys would be in such a database), and (b) what types of various IT controls and considerations Hiroshi should make to address his concerns.
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 kid’s 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.

Order your essay today and save 25% with the discount code: COCONUT

Don't use plagiarized sources. Get Your Custom Essay on
acct
Just from $13/Page
Order Essay

Order a unique copy of this paper

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 25% with the discount code COCONUT