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

FA1 Infoman

QuestionAnswer
Enforcing of standards is applied in file processing approach. True or false?(T/F) False
Different system/programs have separate copies of the same data in database approach. True or false? False
What is a component of a database environment that is the storehouse of the data? Database
The biggest problem in data redundancy is changes in one file could cause inconsistencies. This problem compromises what? Data Integrity
Expand the words in CASE Computer-aided software engineering
In program data dependency, there is coordination and central control of data. True or false? False
Which among the following is an example of an unstructured data Document
Improved data sharing and improved data consistency is found in a database approach. True or false? True
Maintenance in database approach causes more maintenance headaches. True or false? False
Given the choices, which among the following is a disadvantage of file processing wherein it does not have centralized data control? Limited Data Sharing
The external schema shows that different people have different views of the database. True or false? True
E-R models are found in the internal schema of the database. True or false? False
SDLC is a time consuming development cycle but comprehensive. True or false? True
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
The database activity of the logical design step in SDLC is the logical database design.(T/F) True
Which among the following is the first step in SDLC? Planning
What is the step in RAD where the logical database design is made? Develop initial prototype
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(IDK NOT SURE COULD BE BROWSER)
Expand the words RAD. Rapid Application Development
What is the kind of database technology that has started in the 1960s and has became a legacy system in the mid 1980s? Flat Files
The associative entity could have meaning independent of the other entities. 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
What is an attribute or combination of attributes that uniquely identifies individual instances of an entity type? Identifier
A ternary relationship should be converted to an associative entity. True or false? True
In the attributes of the entity PatientHistory, Diagnosis is a simple attribute. True
All relationships for the associative entity should be one to many. True or false? False
All relationships for the associative entity should be many. True or false? True
What is the relationship that links strong entities to weak entities? Identifying relationship
In the entity Patient, Address is a simple attribute. False
Entities of three different types related to each other is a ternary degree of relationship. True or false? True
The biggest problems of file processing are inconsistencies and compromised data integrity.(T/F) True
Is limited data sharing with no centralized control of data a disadvantage of file processing? Yes
What are a graphical system that captures the nature and relationship of data? Data Models
What do you call a planned execution of related tasks to accomplish a goal with a start and finish? [__________]
They are the personnel that is responsible for designing databases and software. System developers
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. [___________]
What is an organized collection of logically related data? Database
What is an element of a database approach that is between entities? Relationships
Projects are initiated and planned during the maintenance stage of SDLC. True or false? False
Operational programs, documentation and training materials are the deliverables of the implementation step in SDLC. True or false? True
Database activity in the maintenance step of SDLC involves database maintenance, performance analysis, and tuning and error tuning. True or false? True
New requirements is always applied to the revised and enhanced prototype in RAD. True or false? True
During the planning stage of SDLC, the database activity here is a thorough and integrated conceptual data modeling. True or false? False
Projects are closed at the end of the maintenance. True or false? False
What is the number of instances of one entity that can be associated with each instance of another entity? Cardinality(Cardinality Constraint)
Multivalued attributes can be represented as relationships. True or false? True
What is an entity that is a combination of relationship and entity? Associative Entity
Relationship degrees specify how many of each entity type is allowed. True or false? False
Entities of three different types related to each other is a binary degree of relationship. True or false? False
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
Entities of two different types related to each other is a binary degree of relationship. 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
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
Which among the following is not an advantage of a database approach? Lack of standards
A good business rule is declarative, precise, atomic, consistent, expressible, distinct, and business-oriented. True or false? True
An SDLC approach to the database has a repeated implementation and maintenance of activities with a new prototype version. True or false? False
One of the problems with data redundancy is the waste of space because of duplicate data. True or false? True
A Text is an example of what kind of data? Structured Data
What kind of database technology started in the 1980s and is under active development as of 2020? Relational
The deliverable of the physical design in SDLC is the program/data structures, technology purchases, and organization redesigns. True or false? True
The deliverable of the logical design of SDLC is the detailed design specification. True or false? True
The purpose of maintenance in SDLC is to monitor, repair and enhance the system. True or false? True
The typical number of users using the personal type of database is only one. True
What is a type of attribute that may take on more than one value for a given entity instance? Multivalued
A required attribute must contain no value for every entity. 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
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
In the attributes of the entity PatientHistory, HistoryId is considered to be a simple attribute. True
What is the storehouse for metadata? Repository
What is a data model that has high-level entities and relationships for the organization? Enterprise data model
One problems of a database approach is compromised data integrity. True or false? False
Data types, field sizes, allowable values, and data context are included in metadata. True or false? True
Non-standard file formats exists in program data dependency. True or false? True
Which schema in the database consists of the user views? External Schema
Implementation and maintenance activities are done repetitively with new prototype versions. True or false? True
Operational programs, documentation and training materials are the deliverables of the maintenance step in SDLC. True or false? False
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
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 the entity Patient, Birthday is a composite attribute True
This cardinality of relationships is an entity in the relationship will have exactly one related entity. one to one
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
A relationship instance is the link between entities. True or false? True
The database approach is a central repository of shared data and data is managed by a controlling agent. True or false? True
One of the costs in database approach is hiring new and specialized personnel to manage the DBMS. True or false? True
In program data dependency, each application program needs to include code for the metadata of each file. True or false? True?
What is a disadvantage of file processing wherein different systems/ programs have separate copies of the same data? Duplication of data
A metadata is a descriptions of the properties or characteristics of the data. True or false? True
What is an element of a database approach that is a noun form describing a person, place, object, event, or concept? Entity
SDLC stands for what? System Development Life Cycle
A functional system specification is the deliverable of the analysis step of SDCL. True or false? True
Develop the technology and organizational specifications is the purpose of the Physical Design in SDLC. True or false? True
The purpose of the physical design step in SDLC is develop technology and organizational specifications. True
A strong entity does not have an identifier. True or false? False
In the attributes of the entity PatientHistory, DoctorId is a simple attribute.(T/F) True
Created by: user-1776272
 

 



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