100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
BCIS 4610 Question and answer already passed 2024 $13.49   Add to cart
Quickly navigate to
Preview
  2.  
  3. BCIS 4610
  4.  
  5. BCIS 4610

Exam (elaborations)

BCIS 4610 Question and answer already passed 2024
 6 views  0 purchase
  • Course
  • BCIS 4610
  • Institution
  • BCIS 4610

BCIS 4610 Question and answer already passed 2024 BCIS 4610, Exam 2, CH 8-14, Dr. Koh, Spring . Class Quizzes & PPTX Conservation of inputs and outputs to a data flow diagram process when that process is decomposed to a lower level is referred to as _______. Balancing Which of the followin...

[Show more]

Preview 4 out of 54  pages

Document information

  • September 3, 2024
  • 54
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • bcis 4610
  • bcis 4610 question and answer already passed 2024

Written for

  • BCIS 4610
  • BCIS 4610

Seller

avatar-seller
Academia199

Reviews received

Content preview

BCIS 4610, Exam 2, CH 8-14, Dr. Koh,
Spring . Class Quizzes & PPTX
Conservation of inputs and outputs to a data flow diagram process when that
process is decomposed to a lower level is referred to as _______.
Balancing




Which of the following is not proper rule that governs DFD?


A No process can have only outputs.
B Data cannot move in two opposite directions between two processes.
C Data cannot move directly from one data store to another data store.
D Data cannot move directly from an outside source to a data store.
D Data cannot move directly from an outside source to a data store.




In the ER model, a person, place, object, event or concept in the user
environment about which data is to be maintained is called a(n) _______.
Entity




In the ER model, a named property or characteristic of an entity that is of
interest to the
organization is referred to as a(n) _______.
Attribute

,The number of entity types that participate in a relationship is referred to as
the _______.


A cardinality
B attribute
C degree
D multiplicity
C. Degree




In a data model for a hospital, a patient is described either as an outpatient or
a resident patient. In this model the patient represents a _______.


A super-type
B sub-type
C hierarchical type
D relational type
B. Sub-type




The _______ is the set of all data types and values that an attribute can
assume.


A attribute type
B cardinality
C variable

,D domain
D. Domains




Which of the following is NOT a property of relations in the relational database
model?


A. Entities in cells are simple.
B. Entries in columns are from the same set of values.
C. Each row is unique.
D. The sequence of the rows cannot be changed.
D. The sequence of the rows cannot be changed.




__________ is the process of converting complex data structures into simple,
stable data structures.
A. Decomposition
B. Normalization
C. Rationalization
D. Simplification
B. Normalization




A relation is in ______ when there are no partical and transitive functional
dependencies.
A. zero normal form (0NF)
B. first normal form (1NF)

, C. second normal form (2NF)
D. third normal form (3NF)
D. third normal form (3NF)




A _____ is an attribute that appears as a nonprimary key attribute in one
relation and as the primary key attribute in another relation.
A. candidate key
B. foreign key
C. secondary key
D. relational key
B. foreign key




____ is an integrity constraint specifying that the value of an attribute in one
relation depends on the value of the same attribute in another relation.
A. Referential integrity
B. Cascade integrity
C. Normal integrity
D. Transfer integrity
A. Referential integrity




The primary key in a relation must satisfy that ______.
A. the value of the key must uniquely identify every row in the relation
B. it must be made of a single attribute

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller Academia199. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $13.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

82871 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$13.49
  • (0)
  Add to cart