100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
BCIS 4610 Question and answer already passed 2024 R243,64   Add to cart

Exam (elaborations)

BCIS 4610 Question and answer already passed 2024

 5 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

  • September 3, 2024
  • 54
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • BCIS 4610
  • BCIS 4610
avatar-seller
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 EFT, 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 this summary 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 this summary for R243,64. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

73243 documents were sold in the last 30 days

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

Start selling
R243,64
  • (0)
  Buy now