CBIS - Test 2 Questions with correct answers.

CBIS - Test 2 Questions with correct answers
Why |isn't |excel |a |great |tool |with |large |amounts |of |complex |data? |- |VERIFIED |ANSWER✔✔-- |Data |
redundancy

- |Data |inconsistency

- |Hard |to |answer |some |questions



data |redundancy |- |VERIFIED |ANSWER✔✔-occurs |when |unnecessary |duplicate |information |exists |in |a |
database



data |inconsistency |- |VERIFIED |ANSWER✔✔-A |condition |in |which |different |versions |of |the |same |data |
yield |different |(inconsistent) |results.



Primary |Key |- |VERIFIED |ANSWER✔✔-A |field |(or |group |of |fields) |that |uniquely |identifies |a |given |entity |
in |a |table



Foreign |Key |- |VERIFIED |ANSWER✔✔-A |primary |key |of |one |table |that |appears |an |attribute |in |another |
table |and |acts |to |provide |a |logical |relationship |among |the |two |tables



What |is |a |database? |- |VERIFIED |ANSWER✔✔-- |A |self-describing |collection |of |Interrelated, |shared, |and
|controlled |data



- |Can |be |processed |by |one |or |more |application |systems |

- |Used |to |support |the |activities |of |a |particular |organizations |

- |A |representation |of |some |aspect |of |the |real |world |or |a |collection |of |data |(facts |+ |symbols)



What |is |relational |database? |- |VERIFIED |ANSWER✔✔-- |A |type |of |database |that |stores |data |in |tables

- |Each |table |is |composed |of |rows |and |columns, |similar |to |a |spreadsheet |

- |Each |row |of |a |table |has |data |about |a |particular |occurrence |or |instance |of |the |of |the |entity |of |
interest

- |Each |column |of |a |table |stores |a |characteristic |or |attributes |common |to |all |rows

, What |does |a |relational |database |store |other |than |data? |- |VERIFIED |ANSWER✔✔-Relationships



Entity |Relationship |Diagram |(ERD) |- |VERIFIED |ANSWER✔✔-A |diagram |that |depicts |an |entity |
relationship |model's |entities, |attributes, |and |relations.



What |is |the |first |step |in |creating |a |database? |- |VERIFIED |ANSWER✔✔-Design |the |database



What |are |some |steps |to |create |a |design |for |a |database? |- |VERIFIED |ANSWER✔✔-- |Understand |the |
goal |of |the |how |the |database |will |be |used |

- |Identify |the |data |needed |as |part |of |accomplishing |this |goal

- |Identify |how |the |data |is |related |to |each |other

- |Identify |tables |and |fields |to |organize |the |data |

| →→Each |tables |needs |a |primary |key |of |which |field(s) |is |unique |to |each |record |and |will |not |change

→→Normalization |is |performed |to |eliminate |duplicated |data



Database |Management |System |(DBMS) |- |VERIFIED |ANSWER✔✔-- |A |program |used |to |create, |process, |
and |administer |a |database

- |E.g., |Microsoft |Access, |OpenOffice |Base, |MySQL, |SQLServer, |etc.



Structured |Query |Language |(SQL) |- |VERIFIED |ANSWER✔✔-- |An |international |standard |language |for |
processing |a |database

- |A |programming |sublanguage |used |within |an |application |to |communicate |with |a |DBMS



Database |Application |- |VERIFIED |ANSWER✔✔-- |A |set |of |one |or |more |computer |programs |that |serves |
as |an |intermediary |between |the |user |and |the |DBMS



Blockchain |- |VERIFIED |ANSWER✔✔-- |A |distributed |ledger |of |transactions

- |A |block |consists |of |multiple |time-stamped |transactions

- |Multiple |blocks |are |joined |together |in |a |chain