Deck 11: Data Storage Design

ملء الشاشة (f)
exit full mode
سؤال
The most popular type of database today is the:

A)Hierarchical database
B)Tree database
C)Green database
D)Relational database
E)Piecemeal database
استخدم زر المسافة أو
up arrow
down arrow
لقلب البطاقة.
سؤال
Which of the following is an open source DBMS?

A)Microsoft Access
B)SQL Server
C)MySQL
D)Excel
E)CASE
سؤال
Which is NOT a type of database file?

A)Hierarchical databases
B)Relational databases
C)Object databases
D)Multidimensional databases
E)Federal database
سؤال
This type of file is used to update a master file:

A)Roster Files
B)Training files
C)Master files
D)Transaction files
E)Integrated files
سؤال
Which of the following is a concept not generally associated with decision support systems?

A)Data warehouses
B)Data marts
C)Aggregated data
D)Object orientation
E)Multidimensional databases
سؤال
The two basic formats for data storage:

A)Spreadsheets and documents
B)Files and databases
C)Databases and presentations
D)Flash and web forms
E)ERDs and Use cases
سؤال
This type of file records "before" and "after" images of data as the data gets altered.

A)Intelligent files
B)Audit files
C)Master files
D)Raw files
E)Prime files
سؤال
Which of the following is NOT a file type described in the textbook?

A)History files
B)Audit files
C)Look-up files
D)Algebra files
E)Transaction files
سؤال
The acronym for the standard language used to access data in relational databases is:

A)ERD
B)CRM
C)ERP
D)BPR
E)SQL
سؤال
Which of the following is not a characteristic of Big Data?

A)Huge volume
B)Rapid velocity
C)Great variety
D)All are characteristics
E)None are characteristics
سؤال
Legacy databases might include ________ and ______________

A)Master files and transaction files
B)Audit files and look-up files
C)Hierarchical databases and network databases
D)Tree databases and leaf databases
E)Red databases and Green databases
سؤال
Which of the following is not a RDBMS?

A)Oracle
B)NoSQL
C)SQL
D)MySQL
E)None of these
سؤال
This type of file stores 'core information that is important to the business' and for the application (such as customer mailing lists).

A)History Files
B)Audit files
C)Master files
D)Transaction files
E)Intelligent files
سؤال
In most cases,decision support systems are best at:

A)Finding particular records that are stored in legacy databases
B)Finding processes that are stored in object databases
C)Finding aggregated data
D)Analyzing audit (or log)files for possible intrusion and security breaches
E)Red and green linked list processing
سؤال
Most relational database systems support:

A)Referential integrity
B)Pop-up menus
C)Customizable user-interface colors and graphics
D)The 'three-clicks' rule
E)Broadband connectivity
سؤال
Document-oriented databases have the following characteristics,except:

A)Large bit files
B)Audio files
C)Video files
D)Files with uniform structure
E)image files
سؤال
Omar is creating an order database for a multiple site car dealership.The data will be fairly simple: names,addresses,city,state,zip code,make of car,model,style,color,etc.Probably the best choice for him would be a _____________ database.

A)Multidimensional
B)Hierarchical
C)Legacy
D)Object
E)Relational
سؤال
Juan is using a file that is created by an older,legacy system.It is likely that the data is:

A)Unusable
B)In a proprietary format
C)In a standard format (like comma separated value)
D)Is sorted by customer's middle name
E)In an object-oriented structure like Ariel
سؤال
New databases collectively referred to as NoSQL databases have appeared in recent years.Which of the following are categorized as a NoSQL database?

A)Document-oriented database
B)Wide column stores
C)Graph databases
D)Extensible record stores
E)Relational Database system
سؤال
Which of the following is not a general function of any application program?

A)Data storage
B)Presentation logic
C)Data access logic
D)Linked-list modules
E)Application logic
سؤال
The CRUD matrix shows

A)The crud that is coming into the system and how to quarantine it
B)Exactly how data are used and created by the major processes in the system
C)The 1:M relationships on an ERD diagram
D)The external entities,process and major data flows from the Context DFD diagram
E)Where customer,relationships,users and developers will interact with a system
سؤال
Which is not a common data type?

A)Character
B)Text
C)Integer
D)Date
E)Video
سؤال
Primary keys are:

A)The same as default keys (or default values)
B)Unique values for each record in a file or table
C)Elementary values (like 'primary' school)
D)Prime numbers in a Fibonacci sequence
E)The same as foreign keys
سؤال
The project team is very knowledgeable about relational database management systems.In terms of feasibility,this might be best known as:

A)Technical feasibility ('can we build it')
B)Economic feasibility ('should we build it')
C)Managerial feasibility ('why would we build it')
D)Graphical feasibility ('does it fit this project')
E)Organizational feasibility ('if we build it,will they use it')
سؤال
Systems that support decision making will probably:

A)Do a lot of updating of data
B)Be transaction processing systems
C)Be audit files
D)Use Gantt charts
E)Usually just read data - and often in ad hoc ways
سؤال
The concept for planning good performance of databases is known as:

A)Volumetrics
B)Econometrics
C)Moving averages
D)Correlation
E)PERT
سؤال
Barb is working on a database design.For the most efficient storage she should remove: ______ and ______.

A)Primary keys and foreign keys
B)International keys and redundancy
C)Adjectives and adverbs
D)Redundancy and null values
E)Special characters and primary keys
سؤال
In a registration database,Ross has tables for student,professor,classroom,class,class-hour.Since his campus has about 12,000 students,when he runs queries about what student is in what class,taught by what professor in what classroom at which hour,the DBMS software will have to perform many _________

A)Axes
B)Parallels
C)Concretes
D)Joins
E)Enrolls
سؤال
The concept of putting records that are somehow related together on the same server (or storage device)is called:

A)Carmelization
B)Clustering
C)Joining
D)Normalization
E)Hybrid technologies
سؤال
The type of processing system that creates reports for supervisors (and other functional users)probably would be a:

A)Transaction Processing System (TPS)
B)Management Information System (MIS)
C)Executive Support System (ESS)
D)Decision Support System (DSS)
E)Rebate Management System (RMS)
سؤال
FoodTitan is a large grocery store chain in the Chicago,Milwaukee,and the Upper Midwest.Generally their stores have from 18 to 36 checkout lanes with scanners.When somebody scans a bar code,the system is probably using a _____ to process the purchased items.

A)Executive support system (ESS)
B)Barcode processing system (BPS)
C)Management information system (MIS)
D)Transaction Processing system (TPS)
E)A grocery store processing system (GSPS)
سؤال
One goal is data storage design is to spread the data over all storage devices so that the redundancy will make for more efficient storage.
سؤال
Many ________ tools like ERwin can help you with database size information and the calculation of volumetrics.

A)ERD master
B)DFD master
C)Denormalization
D)Pop-up menu
E)CASE
سؤال
One activity in the data storage design activity is to update the CRUDE matrix.
سؤال
One common method to increase access speed is to:

A)Use legacy databases in a indexed sequential access method
B)Encrypt all data with 256 byte encryption
C)Denormalize the tables
D)Delete all primary keys
E)Only use alphabetic data
سؤال
A default value is:

A)The first value in a table
B)The median value in a table
C)The smallest value in a table
D)A value that probably occurs most frequently
E)A mistake made by Dee (aka the name "Dee's fault")
سؤال
The purpose of creating physical ERDs is to:

A)Show implementation details and to explain more about the 'how' of the final system
B)Normalize the database to third normal form
C)Do a new technology analysis
D)Drive the users nuts
E)Help junior analysts to find the transactions between systems
سؤال
The most efficient tables (in terms of storage efficiency)in relational database management systems:

A)Have duplicate data,especially for when more than one table is joined together for queries
B)Have no redundant data
C)Are denormalized
D)Have entire tables duplicated
E)Use plasma technologies
سؤال
When you join two relational database tables together,frequently the primary key in one table will be a ____________ in the other table.

A)Foreign key
B)International key
C)Primary key
D)Linked list
E)Entity
سؤال
Marco is working for iTunes and needs to have a database that can store complex data.His best choice might be:

A)An object database
B)A relational database
C)A red-green database
D)A tree database
E)A spanning database
سؤال
A DSS is a design support structure and does the 'ETL' (extract,transform and load)to create data warehouses.
سؤال
Most relational database management systems support 'sticky' quantitative processing.
سؤال
When changing from logical data models to physical data models,you will want to change the attributes of the logical ERD to fields in the physical ERD.
سؤال
Microsoft Access is an end-user DBMS.
سؤال
Systems to support decision making generally need to update data frequently with a large volume of data.
سؤال
Rachel wants aggregated data like find the number of banking customers who have savings accounts over $100,000 and home mortgages with her bank.She probably wants to use a Decision Support System.
سؤال
A relational database that is used extensively in data warehousing is a multidimensional database.
سؤال
Maria is working for the Minneapolis Dance Troop (MDT)and wants a database that can support text,numbers,video,and audio.She will probably select the multidimensional database format.
سؤال
An 'international key' is used to relate two tables together (like customer ID from the customer table is an international key in the order table).
سؤال
One process when considering data storage design is to move from physical data models to logical data models.
سؤال
Data marts are larger,aggregated legacy databases.
سؤال
When changing logical data models to physical data models,you will want to change entities to tables or files.
سؤال
Informix is a pure OODBMS package.
سؤال
Referential integrity is the idea of ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.
سؤال
The standard method language for accessing the data in relational database tables is: SQL - Standard Query Logic.
سؤال
Decision support systems are not designed to find individual records,but to find aggregated information (such as 'what three products sold the best in Boston in February').
سؤال
When working on a major project,project teams will always select and stay with only one database format for consistency of development and use.
سؤال
Jasmine is an example of an object-oriented database system.
سؤال
A great advantage of object oriented database management systems is their easy of learning.
سؤال
Brian wants an e-commerce system to be able to do a lot of rapid processing - like search for particular keywords in documents;return the price of an item;update quantities in the shopping cart.He is probably building an Expert System.
سؤال
The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values.
سؤال
The best design for accessing data faster is generally the most efficient storage as well.
سؤال
If you were considering a media rich database,what type of database organization might be best and why?
سؤال
What is the difference between end-user databases and enterprise databases (and give at least one end-user database product and at least one enterprise database)?
سؤال
What is the CRUD matrix and why should it be updated in the data storage design activity? Give an example of who can "C","R","U" and "D" for a company and sample systems.
سؤال
A CRUD matrix shows exactly how data are used and created by major processes in the system.
سؤال
Although TJ did a lot of work normalizing the database so that it is in third normal form (3NF),he may want to 'denormalize' it so that access might be faster.
سؤال
When moving from logical data models to physical data models,you should update your CRUD matrix.
سؤال
What is the difference between files and relational databases?
سؤال
The two primary ways to optimize a relational database are (a)for storage efficiency and (b)for using the smallest amount of space.
سؤال
CRUD stands for 'create','read','update' and 'delete'.
سؤال
When converting a logical ERD into a physical data model,you will want to specify both primary keys and international keys.
سؤال
What is SQL? And what is its usage in relational databases?
سؤال
Sanjay is creating a screen form that interfaces with a relational database.He should use the median (middle)value in the database as his default value - as that will make it easier for the users to move up and down in the table.
فتح الحزمة
قم بالتسجيل لفتح البطاقات في هذه المجموعة!
Unlock Deck
Unlock Deck
1/74
auto play flashcards
العب
simple tutorial
ملء الشاشة (f)
exit full mode
Deck 11: Data Storage Design
1
The most popular type of database today is the:

A)Hierarchical database
B)Tree database
C)Green database
D)Relational database
E)Piecemeal database
D
2
Which of the following is an open source DBMS?

A)Microsoft Access
B)SQL Server
C)MySQL
D)Excel
E)CASE
C
3
Which is NOT a type of database file?

A)Hierarchical databases
B)Relational databases
C)Object databases
D)Multidimensional databases
E)Federal database
E
4
This type of file is used to update a master file:

A)Roster Files
B)Training files
C)Master files
D)Transaction files
E)Integrated files
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
5
Which of the following is a concept not generally associated with decision support systems?

A)Data warehouses
B)Data marts
C)Aggregated data
D)Object orientation
E)Multidimensional databases
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
6
The two basic formats for data storage:

A)Spreadsheets and documents
B)Files and databases
C)Databases and presentations
D)Flash and web forms
E)ERDs and Use cases
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
7
This type of file records "before" and "after" images of data as the data gets altered.

A)Intelligent files
B)Audit files
C)Master files
D)Raw files
E)Prime files
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
8
Which of the following is NOT a file type described in the textbook?

A)History files
B)Audit files
C)Look-up files
D)Algebra files
E)Transaction files
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
9
The acronym for the standard language used to access data in relational databases is:

A)ERD
B)CRM
C)ERP
D)BPR
E)SQL
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
10
Which of the following is not a characteristic of Big Data?

A)Huge volume
B)Rapid velocity
C)Great variety
D)All are characteristics
E)None are characteristics
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
11
Legacy databases might include ________ and ______________

A)Master files and transaction files
B)Audit files and look-up files
C)Hierarchical databases and network databases
D)Tree databases and leaf databases
E)Red databases and Green databases
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
12
Which of the following is not a RDBMS?

A)Oracle
B)NoSQL
C)SQL
D)MySQL
E)None of these
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
13
This type of file stores 'core information that is important to the business' and for the application (such as customer mailing lists).

A)History Files
B)Audit files
C)Master files
D)Transaction files
E)Intelligent files
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
14
In most cases,decision support systems are best at:

A)Finding particular records that are stored in legacy databases
B)Finding processes that are stored in object databases
C)Finding aggregated data
D)Analyzing audit (or log)files for possible intrusion and security breaches
E)Red and green linked list processing
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
15
Most relational database systems support:

A)Referential integrity
B)Pop-up menus
C)Customizable user-interface colors and graphics
D)The 'three-clicks' rule
E)Broadband connectivity
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
16
Document-oriented databases have the following characteristics,except:

A)Large bit files
B)Audio files
C)Video files
D)Files with uniform structure
E)image files
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
17
Omar is creating an order database for a multiple site car dealership.The data will be fairly simple: names,addresses,city,state,zip code,make of car,model,style,color,etc.Probably the best choice for him would be a _____________ database.

A)Multidimensional
B)Hierarchical
C)Legacy
D)Object
E)Relational
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
18
Juan is using a file that is created by an older,legacy system.It is likely that the data is:

A)Unusable
B)In a proprietary format
C)In a standard format (like comma separated value)
D)Is sorted by customer's middle name
E)In an object-oriented structure like Ariel
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
19
New databases collectively referred to as NoSQL databases have appeared in recent years.Which of the following are categorized as a NoSQL database?

A)Document-oriented database
B)Wide column stores
C)Graph databases
D)Extensible record stores
E)Relational Database system
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
20
Which of the following is not a general function of any application program?

A)Data storage
B)Presentation logic
C)Data access logic
D)Linked-list modules
E)Application logic
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
21
The CRUD matrix shows

A)The crud that is coming into the system and how to quarantine it
B)Exactly how data are used and created by the major processes in the system
C)The 1:M relationships on an ERD diagram
D)The external entities,process and major data flows from the Context DFD diagram
E)Where customer,relationships,users and developers will interact with a system
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
22
Which is not a common data type?

A)Character
B)Text
C)Integer
D)Date
E)Video
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
23
Primary keys are:

A)The same as default keys (or default values)
B)Unique values for each record in a file or table
C)Elementary values (like 'primary' school)
D)Prime numbers in a Fibonacci sequence
E)The same as foreign keys
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
24
The project team is very knowledgeable about relational database management systems.In terms of feasibility,this might be best known as:

A)Technical feasibility ('can we build it')
B)Economic feasibility ('should we build it')
C)Managerial feasibility ('why would we build it')
D)Graphical feasibility ('does it fit this project')
E)Organizational feasibility ('if we build it,will they use it')
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
25
Systems that support decision making will probably:

A)Do a lot of updating of data
B)Be transaction processing systems
C)Be audit files
D)Use Gantt charts
E)Usually just read data - and often in ad hoc ways
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
26
The concept for planning good performance of databases is known as:

A)Volumetrics
B)Econometrics
C)Moving averages
D)Correlation
E)PERT
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
27
Barb is working on a database design.For the most efficient storage she should remove: ______ and ______.

A)Primary keys and foreign keys
B)International keys and redundancy
C)Adjectives and adverbs
D)Redundancy and null values
E)Special characters and primary keys
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
28
In a registration database,Ross has tables for student,professor,classroom,class,class-hour.Since his campus has about 12,000 students,when he runs queries about what student is in what class,taught by what professor in what classroom at which hour,the DBMS software will have to perform many _________

A)Axes
B)Parallels
C)Concretes
D)Joins
E)Enrolls
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
29
The concept of putting records that are somehow related together on the same server (or storage device)is called:

A)Carmelization
B)Clustering
C)Joining
D)Normalization
E)Hybrid technologies
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
30
The type of processing system that creates reports for supervisors (and other functional users)probably would be a:

A)Transaction Processing System (TPS)
B)Management Information System (MIS)
C)Executive Support System (ESS)
D)Decision Support System (DSS)
E)Rebate Management System (RMS)
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
31
FoodTitan is a large grocery store chain in the Chicago,Milwaukee,and the Upper Midwest.Generally their stores have from 18 to 36 checkout lanes with scanners.When somebody scans a bar code,the system is probably using a _____ to process the purchased items.

A)Executive support system (ESS)
B)Barcode processing system (BPS)
C)Management information system (MIS)
D)Transaction Processing system (TPS)
E)A grocery store processing system (GSPS)
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
32
One goal is data storage design is to spread the data over all storage devices so that the redundancy will make for more efficient storage.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
33
Many ________ tools like ERwin can help you with database size information and the calculation of volumetrics.

A)ERD master
B)DFD master
C)Denormalization
D)Pop-up menu
E)CASE
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
34
One activity in the data storage design activity is to update the CRUDE matrix.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
35
One common method to increase access speed is to:

A)Use legacy databases in a indexed sequential access method
B)Encrypt all data with 256 byte encryption
C)Denormalize the tables
D)Delete all primary keys
E)Only use alphabetic data
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
36
A default value is:

A)The first value in a table
B)The median value in a table
C)The smallest value in a table
D)A value that probably occurs most frequently
E)A mistake made by Dee (aka the name "Dee's fault")
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
37
The purpose of creating physical ERDs is to:

A)Show implementation details and to explain more about the 'how' of the final system
B)Normalize the database to third normal form
C)Do a new technology analysis
D)Drive the users nuts
E)Help junior analysts to find the transactions between systems
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
38
The most efficient tables (in terms of storage efficiency)in relational database management systems:

A)Have duplicate data,especially for when more than one table is joined together for queries
B)Have no redundant data
C)Are denormalized
D)Have entire tables duplicated
E)Use plasma technologies
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
39
When you join two relational database tables together,frequently the primary key in one table will be a ____________ in the other table.

A)Foreign key
B)International key
C)Primary key
D)Linked list
E)Entity
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
40
Marco is working for iTunes and needs to have a database that can store complex data.His best choice might be:

A)An object database
B)A relational database
C)A red-green database
D)A tree database
E)A spanning database
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
41
A DSS is a design support structure and does the 'ETL' (extract,transform and load)to create data warehouses.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
42
Most relational database management systems support 'sticky' quantitative processing.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
43
When changing from logical data models to physical data models,you will want to change the attributes of the logical ERD to fields in the physical ERD.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
44
Microsoft Access is an end-user DBMS.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
45
Systems to support decision making generally need to update data frequently with a large volume of data.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
46
Rachel wants aggregated data like find the number of banking customers who have savings accounts over $100,000 and home mortgages with her bank.She probably wants to use a Decision Support System.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
47
A relational database that is used extensively in data warehousing is a multidimensional database.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
48
Maria is working for the Minneapolis Dance Troop (MDT)and wants a database that can support text,numbers,video,and audio.She will probably select the multidimensional database format.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
49
An 'international key' is used to relate two tables together (like customer ID from the customer table is an international key in the order table).
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
50
One process when considering data storage design is to move from physical data models to logical data models.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
51
Data marts are larger,aggregated legacy databases.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
52
When changing logical data models to physical data models,you will want to change entities to tables or files.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
53
Informix is a pure OODBMS package.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
54
Referential integrity is the idea of ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
55
The standard method language for accessing the data in relational database tables is: SQL - Standard Query Logic.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
56
Decision support systems are not designed to find individual records,but to find aggregated information (such as 'what three products sold the best in Boston in February').
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
57
When working on a major project,project teams will always select and stay with only one database format for consistency of development and use.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
58
Jasmine is an example of an object-oriented database system.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
59
A great advantage of object oriented database management systems is their easy of learning.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
60
Brian wants an e-commerce system to be able to do a lot of rapid processing - like search for particular keywords in documents;return the price of an item;update quantities in the shopping cart.He is probably building an Expert System.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
61
The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
62
The best design for accessing data faster is generally the most efficient storage as well.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
63
If you were considering a media rich database,what type of database organization might be best and why?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
64
What is the difference between end-user databases and enterprise databases (and give at least one end-user database product and at least one enterprise database)?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
65
What is the CRUD matrix and why should it be updated in the data storage design activity? Give an example of who can "C","R","U" and "D" for a company and sample systems.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
66
A CRUD matrix shows exactly how data are used and created by major processes in the system.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
67
Although TJ did a lot of work normalizing the database so that it is in third normal form (3NF),he may want to 'denormalize' it so that access might be faster.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
68
When moving from logical data models to physical data models,you should update your CRUD matrix.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
69
What is the difference between files and relational databases?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
70
The two primary ways to optimize a relational database are (a)for storage efficiency and (b)for using the smallest amount of space.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
71
CRUD stands for 'create','read','update' and 'delete'.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
72
When converting a logical ERD into a physical data model,you will want to specify both primary keys and international keys.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
73
What is SQL? And what is its usage in relational databases?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
74
Sanjay is creating a screen form that interfaces with a relational database.He should use the median (middle)value in the database as his default value - as that will make it easier for the users to move up and down in the table.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.
فتح الحزمة
k this deck
locked card icon
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 74 في هذه المجموعة.