Question
TEST 2: PLEASE MATCHINGWITH OPTION (F, G, H, I, J) ____ the practice of examining large databases in order to generate new information ____ The
TEST 2:
PLEASE MATCHINGWITH OPTION (F, G, H, I, J)
____ the practice of examining large databases in order to generate new information
____ The format of a data record, which includes the name, type and size of each field in the record.
____ tells the users, in their term, what is in the database. So while there can be numerous
____ the way data are physically stored and processed in a database, there can only be one physical view of a database because physical view deals with the physical storage of information on a storage device
____ a way to logically group objects such as tables, views, stored procedures etc.
F.Physical View
G.Logical View
H.Record Layout
I.Data Mining.
J.Schema
TEST 3: MATCHING WITH OPTION K, L, M, N, O
____ahigh-leveldescriptionofabusiness'sinformationalneeds.It typically includes only the main concepts and the main relationships among
them.
____ It is tailored to the needs of a particular category of users. Portions of Level Schema stored data should not be seen by some users and begins to implement a level of security and simplifies the view for these users I
____ the logical description of thatsection of the database which is. Level relevant and available to an application.
__ is a key in a relational database that is unique for each record. It is a uniqueidentifier,such asadriverlicensenumber,telephonenumber (including area code), or vehicle identification number (VIN)
____ a column (or columns) that references a column (most often the primary key) of another table. The purpose of the foreign key is to ensure
referential integrity of the data.
K.Subschema
L. External Level Schema
M. Conceptual Level Schema
N.Foreign Key
O.Primary Key
TEST 4: MATCHING WITH OPTION P,Q,R,S,T
___ a data inconsistency that results from data redundancy and a partial update
____ occurs when certain attributes cannot be inserted into the database without the presence of other attributes.- we can't add a new course unless we have at least one student enrolled on the course.
____ exists when certain attributes are lost because of the deletion of other attributes.
____structuredtorecognizerelationsamongstoreditemsof information.
____ a basic constraint of database relational model (abbreviated RM) that refers to the morphology of the primary key but after words, the same format is applied to the foreign key and, also to any of simple components of any of two.
P.Insert Anomaly
Q.Update Anomaly.
R.Entity Integrity Rule
S.Relational Database
T.Delete Anomaly
TEST 5: MATCHING WITH OPTION U,V
____Process of organizing the columns (attributes) and tables (relations) of a relational database to minimize data redundancy.
____ a software engineering model based on relationships between stored symbols and the real world. The data is organized in such a waythatitcanbeinterpretedmeaningfullywithouthuman intervention.
U.Normalization
V.Semantic Data Modeling
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started