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 F1

QuestionAnswer
What is a software system that is used to create, maintain, and provide controlled access to user databases? Database Management System
One of the costs in database approach is hiring new and specialized personnel to manage the DBMS. Is the statement true or false? True
Enforcing of standards is applied in file processing approach. Is the statement true or false? False
A metadata is a descriptions of the properties or characteristics of the data. Is the statement true or false? True
Improved data sharing and improved data consistency is found in a database approach. Is the statement true or false? True
Non-standard file formats exists in program data dependency. Is the statement true or false? True
In program data dependency, there is coordination and central control of data. Is the statement true or false? False
Who are the personnel that is responsible for designing databases and software? System developers
What approach in database development that is time-consuming, but comprehensive? SDLC
What are a graphical system that captures the nature and relationship of data? Data models
Periodic audits is the deliverable of the maintenance step in SDLC. True or false? True
What is the step in SDLC that its purpose is a thorough requirements analysis and structuring the system? Analysis
Which among the following became a legacy system during the 1990s? Network
Analyzing database to ensure it meets application needs and fixing the errors of the database is in what process of RAD? Database Maintenance
Implementation and maintenance activities are done repetitively with new prototype versions. True or false? True
Information requirement elicitation and structure is the purpose of the logical design in SDLC. True or false? True
E-R models are found in the conceptual schema of the database. True or false? True
SDLC is a time consuming development cycle but comprehensive. True or false? True
The purpose of the physical design step in SDLC is information requirements elicitation and structure. True or false? False
The internal schema of the database involves the logical and physical structures of the database. True or false? True
A ternary relationship should be converted to an associative entity. True or false? True
The associative entity could have meaning independent of the other entities. True or false? True
The associative entity preferably has a unique identifier, and should also have other attributes. True or false? True
Relationship degrees specify how many of each entity type is allowed. Is this true or false? False
A unary degree of the relationship is an entity related to another of the same entity type. True or false? True
There may be a value for every entity in an optional attribute. True or false? True
An associative entity is like a relationship with an attribute, but it is also considered to be an entity in its own right. True or false? True
This cardinality of relationship shows entities on both sides of the relationship can have many related entities on the other side. many to many
Which among the following are inappropriate entities of an ERD Credit Report
In the entity Patient, PatientName is a composite attribute. True
The database approach stores a data in a standardized, convenient form. Is the statement true or false? True
It's a database technique where the database is defined during the creation of the original prototype, and the implementation and maintenance tasks are repeated with new prototype iterations. [___________] PROTOTYPING
The biggest problem in data redundancy is changes in one file could cause inconsistencies. This problem compromises what? Data integrity
Different system/programs have separate copies of the same data in database approach. Is the statement true or false? False
Maintenance in database approach causes more maintenance headaches. Is the statement true or false? False
Is limited data sharing with no centralized control of data a disadvantage of file processing? Yes
Given the choices, which among the following is a disadvantage of file processing wherein programmers must design their own formats? Lengthy Development times
In program data dependency, each application program needs to include code for the metadata of each file. Is the statement true or false? True
What do you call a planned execution of related tasks to accomplish a goal with a start and finish? PROJECT
A good business rule is declarative, precise, atomic, consistent, expressible, distinct, and business-oriented. Is the statement true or false? True
Which among the following is an example of an unstructured data large text documents
The waste of space caused by having duplicate data is a challenge with database approaches. Is the statement true or false? False
What is a data model that has high-level entities and relationships for the organization? Enterprise data model
What is a disadvantage of file processing wherein different systems/ programs have separate copies of the same data? Duplication of data
Data types, field sizes, allowable values, and data context are included in metadata. Is the statement true or false? True
What is a repository of shared data that is stored in a standardized, convenient form that is managed by a controlling agent? DATABASE
A functional system specification is the deliverable of the analysis step of SDCL. True or false? True
The internal schema is the underlying design and implementation of the database. True or false? False
The deliverable of the logical design of SDLC is the detailed design specification. True or false? True
Projects are initiated and planned during the maintenance stage of SDLC. True or false? False
SDLC stands for what? System Development Life Cycle
Expand the words RAD. Rapid Application Development
Which among the following is the first step in SDLC? Planning
During the planning stage of SDLC, the database activity here is a thorough and integrated conceptual data modeling. True or false? False
The ___________ is called the number of instances of one entity that can or must be associated with each instance of another entity. cardinality constraint
In choosing an identifier for an entity, choose an entity that will not change in value and will not be null. True or false? True
This cardinality of relationships is an entity in the relationship will have exactly one related entity. one to one
What is the relationship that links strong entities to weak entities? Identifying relationship
This cardinality of relationship shows an entity on one side of the relationship which can have many related entities, but an entity on the other side will have a maximum of one related entity. What cardinality is this? one to many
What is the number of instances of one entity that can be associated with each instance of another entity? Cardinality
Entities of three different types related to each other is a binary degree of relationship. True or false? False
What is an attribute or combination of attributes that uniquely identifies individual instances of an entity type? Identifier
A metadata is a data that characterizes the properties and context of user data. True
Program data dependence is a disadvantage of file processing wherein all programs maintain metadata for each file they use. Is the statement true or false? True
Which among the following is not an advantage of a database approach? Lack of standards
Inconsistencies are always found in a database approach. Is the statement true or false? False
One of the costs in database approach is the conversion costs. Is the statement true or false? True
What is a component of a database environment that is the storehouse of the data? Database
What approach in database development that is time-consuming, but comprehensive? SDLC
Expand the words in CASE. Computer-aided software engineering
What is an element of a database approach that is between entities? Relationships
Given the choices, which among the following is a not a disadvantage of file processing wherein it does not have centralized data control? Data Sharing Availability
A Text is an example of what kind of data? Structured Data
What is a data model that has a more detailed view and matching data structure in the database or data warehouse? Project data model
One problems of a database approach is compromised data integrity. Is the statement true or false? False
What kind of database technology started in the 1980s and is under active development as of 2020? Relational
Enterprise modeling and early conceptual data modeling are the database activity during the planning stage of SDLC. True or false? True
The external schema shows that different people have different views of the database. True or false? True
Converting to an operational system in RAD usually means database maintenance. True or false? True
SDLC is a long development cycle. True
Attributes that contains data that will change overtime is the best attribute for an identifier. True or false? False
A required attribute must have a value for every entity. True or false? True
In the diagram 1, what is the cardinality of the relationship between entities? one to many
A strong entity does not have an identifier. True or false? False
In the attributes of the entity PatientHistory, HistoryId is considered to be a simple attribute. True
These are the or characteristics of an entity or relationship type. Attributes
Which among the attribute of both entities is mutivalued? Symptom
In defining attributes, it is important to make it clear what it is and is not included in the attribute’s value. True or false? True
In the attributes of the entity PatientHistory, Diagnosis is a simple attribute. True
What example software uses data in a database environment? Application Programs
One of the problems with data redundancy is the waste of space because of duplicate data. Is the statement true or false? True
Improved data sharing and improved data consistency is found in a database approach. Is the statement true or false? True
An SDLC approach to the database has a repeated implementation and maintenance of activities with a new prototype version. Is the statement true or false? False
The database approach is a central repository of shared data and data is managed by a controlling agent. Is the statement true or false? True
What is an organized collection of logically related data? Metadata
What do you call the people who use the applications and the database? End users
Database activity in the maintenance step of SDLC involves database maintenance, performance analysis, and tuning and error tuning. True or false? True
The purpose of Planning in SDLC is the preliminary understanding of what the system is. True or false? True
Develop the technology and organizational specifications is the purpose of the Logical Design in SDLC. True or false? False
The database activity of the physical design in SDLC is defining the database to DBMS, physical data organization, and database processing programs. True or false? True
External schema is the subset of the conceptual schema. True or false? True
Which schema in the database consists of the user views? External Schema
What is a type of attribute whose values can be calculated from related attribute value? Derived
A dependent entity is another name for weak entity. True or false? True
A composite attribute has meaningful component parts. True or false? True
An optional attribute means that the value can be left blank. True or false? True
All relationships for the associative entity should be one to many. True or false? False
Perfect identifiers are the attributes that contain locations. True or false? False
CASE tools are not a part of the database environment. Is the statement true or false? False
Tables that represent entities and primary/foreign keys that reflect relationships make up a relational database. Is the statement true or false? True
What is the storehouse for metadata? Repository
Expand the words in CASE. Computer-aided software engineering
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
A Number is an example of what kind of data? Structured
A date is an example of what kind of data? Structured
An image is an example of what kind of data? Unstructured
An video is an example of what kind of data? Unstructured
A document is an example of what kind of data? Unstructured
Develop the technology and organizational specifications is the purpose of the Physical Design in SDLC. True or false? True
What is the step in RAD where the logical database design is made? Develop initial prototype
A data warehouse is an integrated decision support system derived from various operational databases. True or false? True
The RAD type of development process define database during development of initial prototype. True
In the entity Patient, Birthday is a composite attribute True
The associative entity may participate in other relationships other than the entities of the associated relationship. True or false? True
The biggest problems of file processing are inconsistencies and compromised data integrity. Is the statement true or false? True
What is the database application that integrates all enterprise functions (manufacturing, finance, sales, marketing, inventory, accounting, human resources)? Enterprise Resource Planning
E-R models are found in the internal schema of the database. True or false? False
New requirements is always applied to the revised and enhanced prototype in RAD. True or false? True
The purpose of maintenance in SDLC is to monitor, repair and enhance the system. True or false? True
The purpose of the physical design step in SDLC is develop technology and organizational specifications. True
The purpose of the implementation step in SDLC is the programming, testing, training, installation, and documenting the system. True or false? True
Entities of two different types related to each other is a binary degree of relationship. True or false? True
Unary relationships should be converted to associative entities. True or false? False
What is a type of attribute that may take on more than one value for a given entity instance? Multivalued
In the attributes of the entity PatientHistory, DoctorId is a simple attribute. True
All relationships for the associative entity should be many. True or false? True
Minimum cardinality can have a fixed lower limit constraint. True or false? True
In the attributes of the entity PatientHistory, DoctorId is a composite attribute. False
The typical number of users using the personal type of database is only one. True
Operational programs, documentation and training materials are the deliverables of the maintenance step in SDLC. True or false? True
In a three tiered client server database architecture, what is the database that contains all organizational data or summaries of data on department servers web tier ?
Entities of three different types related to each other is a ternary degree of relationship. True or false? True
In the attributes of the entity PatientHistory, CheckinDate is a simple attribute. False
What is the centralized storehouse of metadata? Repository
In the entity Patient, Address is a simple attribute. False
The degree of the relationship is the number of entity types that participate in a relationship. True or false? True
What is an entity that is a combination of relationship and entity? Associative Entity
The deliverable of the physical design in SDLC is the program/data structures, technology purchases, and organization redesigns. True or false? True
What is the kind of database technology that has started in the 1960s and has became a legacy system in the mid 1980s? Hierarchical
A required attribute must contain no value for every entity. True or false? False
A relationship instance is the link between entities. True or false? True
Created by: xd-xdd
 

 



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