Save
Upgrade to remove ads
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

Info Man M1

INFORMATION MANAGEMENT M1

QuestionAnswer
Given the choices, which among the following is a disadvantage of file processing wherein programmers must design their own formats? Excessive Program Maintenance Program-data dependence Lengthy Development times Limited data sharing Excessive Program Maintenance
CASE tools are not a part of the database environment True False False;
The database approach is a central repository of shared data is managed by a controlling agent. True or False? True False True;
What is an organized collection of logically related data? Relation Database Tables Metadata Database
The biggest problems of file processing are inconsistencies and compromised data integrity True False True;
Data types, field sizes, allowable values, and data context are included in metadata. True or false? True False True;
What is an element of the database approach wherein it is composed of attributes and it's a noun form describing a person, place, object or concept? Entities Relationships Relational database Data Models Entities;
A Text is an example of what kind of data? Characters Document Structured Data Unstructured Data Unstructured Data
One problems of a database approach is compromised data integrity. True or False? True False False;
The deliverables of the logical design of SDLC is the detailed design specification. True or false? True False True;
Which among the following is the first step in SDLC? Logical design Planning Implementation Maintenance Planning
Analyzing database to ensure it meets application needs and fixing the errors of the database is in what process of RAD? Database Maintenance Conceptual data modeling Database implementation Physical database design and definition Database Maintenance
Which schema in the database consists of the user views? Internal Schema External Schema Conceptual Schema External Schema;
Periodic audits is the deliverable of the maintenance step in SDLC. True or false? True False True
New requirements is always applied to the revised and enhanced prototype in RAD. True or false? True False True;
The purpose of Planning in SDLC is the preliminary understanding of what the system is. True or false? True False True
The database activity of the logical design step in SDLC is the logical database design True False True
Operational programs, documentation and training materials are the deliverables of the implementation step in SDLC. True or false? True False True
What is the step in SDLC that its purpose is a thorough requirements analysis and structuring system? Implementation Planning Logical Design Analysis Analysis
The associative entity preferably has a unique identifier, and should also have other attributes. True or false? True False True
What is an attribute or combination of attributes that uniquely identifies individual instances of an entity type? Composite Combined attribute Partial Identifier Identifier Identifier
In the entity Patient, PatientName is a composite attribute. True False True
The associative entity may participate in other relationships other than the entities of the associated relationship. True or false? True False True
In the attributes of the entity PatientHistory, DoctorId is a simple attribute True False True
In the attributes of entity PatientHistory, HistoryId is considered to be a simple attribute True False True
Entities of three different types related to each other is a ternary degree of relationship. True or false? True False True;
A required attribute must have a value for every entity. True or false? True False True
What is the number of instances of one entity that can be associated with each instance of another entity? Associative Numbering Cardinality Instance Numbering Degree of the relationship Cardinality
Perfect identifiers are the attributes that contain locations. True or false? True False False
What is the centralized storehouse of metadata? Repository DBMS Database CASE tools Repository;
One if the costs in database approach is the conversion costs. True false? True False True
Tables that represent entities and primary/foreign keys that reflect relationships make up a relational database. True or false? True False True;
A good business rule is declarative, precise, atomic, consistent, expressible, distinct, and business-oriented. True or false? True False True
An SDLC approach to the database has a repeated implementation and maintenance of activities with a new prototype version. True or false? True False False;
Expand the words in CASE. Computer Architecture Software Enterprise Computer Aided Solid Engineering Computer-aided software engineering Computer Artists Strong Enterprise Computer-aided software engineering
Enforcing of standards is applied in file processing approach. True or false? True False False;
The internal schema of the database involves the logical and physical structures of the database. True or false? True False True
These are the or characteristics of an entity or relationship type Media Relationship Attributes Entities Attributes
In choosing an identifier for an entity, choose an entity, choose an entity that will not change in value and will not be null. True or false? True False True
Multivalued attributes can be represented as relationship. True or false? True False True
What is a type of attribute that may take on more than one value for a given entity instance? Derived Composite Multivalued Simple Multivalued
What is a type of attribute whose values can be calculated from related attribute value? Composite Multivalued Required Derived Derived;
The database approach stores a data in a standardized, convenient form. True or false? True False True
What is a software system that is used to create, maintain, and provide controlled access to user databases? Metadata Data Dominance Data Management System Data control Database Management System
One of the problems with data redundancy is the waste of space because of duplicate data. True or false? True False True
Is limited data sharing with no centralized control of data a disadvantage of file processing? Yes No Yes
The purpose of the physical design step in SDLC is develop technology and organizational specifications. True False True;
The purpose of the physical design step in SDLC is information requirements elicitation and structure. True or false? True False False
The purpose of the implement step in SDLC is the programming, testing, training, installation, and documenting the system. True or false? True False True
Which among the following became a legacy system during the 1990s? Data Warehousing Network object-relational Object-oriented Network
Request for study is the deliverable in the planning step of SDLC. True or false? True False True;
The purpose of maintenance in SDLC is to monitor, repair and enhance the system. True or false? True False True
SDLC stands for what? System Direct Life Cycle Solid Development Life Cycle System Delivering Low Cycle System Development Life Cycle System Development Life Cycle
A ternary relationship should be converted to an associative entity. True or false? True False True
All relationships for the associative entity should be many. True or false? True False True;
Entities of three different types related to each other is a binary degree of relationship. True or false? True False False
Attributes that contains data that will change overtime is the best attribute for an identifier. True or false? True False False
Which among the attribute of both entities is multivalued? DoctorId Birthday Address Symptom Symptom
The ______ is called the number of instances of one entity that can or must be associated with each instance of another entity. unique constraint cardinality constraint number constraint integrity constraint cardinality constraint
In the attributes of the entity PatientHistory, Diagnosis is a simple attribute True False False
What is an entity that is a combination of relationship and entity? Associative Entity EntiRel Double Entity Combined Entity Associative Entity
Created by: akosi.A
 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards