DFDs - correct answers Two main purposes:
Understanding a business process
Understanding the relational database that underlies the AIS
Focus on data
A circle in a data flow diagram represents:
A) A data flow
B) An external entity
C) A database
D) A business process
E) A repeat loop - correct answers D) A business process
Which of the following statements about systems flowcharts and data flow
diagrams is most true?
A) Processes are numbered in a flowchart, but not a data flow diagrams.
B) Processes are numbered in a data flow diagrams, but not a flowchart
C) Processes are numbered in both flowcharts and data flow diagrams.
D) Processes are numbered in neither flowcharts nor data flow diagrams. - correct
answers
, Primary key: - correct answers a field in a table that uniquely identifies every
record in that table
Foreign key: - correct answers a primary key in one table that is included in
another table for linking purposes
Compound primary key: - correct answers two or more fields in a table that
together comprise its primary key
Booksellers of Buffalo is a small, independent bookstore that both publishes and
sells very specialized titles. They currently have about 50 clients; they publish and
sell 30 different books at present. The company's management has asked you to
create database tables to support their operations. Any database tables that are in
third normal form should:
A) Eliminate repeating groups.
B) Eliminate redundant data.
C) Eliminate columns not dependent on the primary key.
D) All of the above. - correct answers D) All of the above.
Pre-quiz:
Every _______ in a database table must be uniquely identified with a _________.
a.
field, primary key
b.
The benefits of buying summaries with Stuvia:
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
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
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 Schoolflix. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R252,73. You're not tied to anything after your purchase.