Redundant data increases the risk of data anomalies when you perform which of th
ID: 3761625 • Letter: R
Question
Redundant data increases the risk of data anomalies when you perform which of the following actions:
1.Insert data
2.Update data
3.delete data
4.all the above
------------------------------------
2.Microsoft Access is an example of which of the following:
Enterprise-class database system
Personal database system
Business-class database system
None of the above
------------------------------------------------------
3.One of the desirable characteristics of a primary key is:
It contains useful information about the row
It may change and adapt as the database grows.
It is minimal.
It should allow us to use the same value to identify multiple rows
----------------------------------------------------------------
4.A surrogate key should be avoided if at all possible
true
false
-------------------------------------------------
5.The process of breaking a table into with more than one theme into two or more tables each with only one theme, thus eliminating redundancy, is called:
Functional dependency
Relating
Deconstructing
Normalization
------------------------------------------------------------
6.all versions of SQL run properly with Microsoft Access
true
false
------------------------------------------
7.In a 1:N relationship, the entity on the “one” side of the relationship is referred to as the __ and the entity on the “many” side is referred to as the __
Parent…child
Child...Parent
Preceding…Succeeding
Succeeding…Preceding
--------------------------------------------------------------------
8.An entity that cannot exist in a database unless another type of entity also exists is called a:
Dependent entity
Strong entity
Special entity
Weak entity
--------------------------------------------------------------------
9.An attribute of a supertype entity that indicates which of the subtypes is appropriate for a given instance is called a(n):
Discriminator
Determiner
Instance option
Association
-----------------------------------------------------
10.What is normalization? Explain why it is important.
11.List and describe the 4 components of a database system.
12.
Write the SQL SELECT statement to display the average rent of the properties.
Use the following PROPERTY table to answer the question:
475
13.
Write the SQL SELECT statement to display the property type, rooms, and rent sorted by the Type.
Use the following PROPERTY table to answer the question:
Enterprise-class database system
Personal database system
Business-class database system
None of the above
------------------------------------------------------
3.One of the desirable characteristics of a primary key is:
It contains useful information about the row
It may change and adapt as the database grows.
It is minimal.
It should allow us to use the same value to identify multiple rows
----------------------------------------------------------------
4.A surrogate key should be avoided if at all possible
true
false
-------------------------------------------------
5.The process of breaking a table into with more than one theme into two or more tables each with only one theme, thus eliminating redundancy, is called:
Functional dependency
Relating
Deconstructing
Normalization
------------------------------------------------------------
6.all versions of SQL run properly with Microsoft Access
true
false
------------------------------------------
7.In a 1:N relationship, the entity on the “one” side of the relationship is referred to as the __ and the entity on the “many” side is referred to as the __
Parent…child
Child...Parent
Preceding…Succeeding
Succeeding…Preceding
--------------------------------------------------------------------
8.An entity that cannot exist in a database unless another type of entity also exists is called a:
Dependent entity
Strong entity
Special entity
Weak entity
--------------------------------------------------------------------
9.An attribute of a supertype entity that indicates which of the subtypes is appropriate for a given instance is called a(n):
Discriminator
Determiner
Instance option
Association
-----------------------------------------------------
10.What is normalization? Explain why it is important.
11.List and describe the 4 components of a database system.
12.
Write the SQL SELECT statement to display the average rent of the properties.
Use the following PROPERTY table to answer the question:
PropertyID Type Rooms Rent 306 Apt 3 550 308 House 6 1000 325 Apt 4 625 397 Apt 3 550 412 House 7 1250 441 Apt 2475
13.
Write the SQL SELECT statement to display the property type, rooms, and rent sorted by the Type.
Use the following PROPERTY table to answer the question:
PropertyID Type Rooms Rent 306 Apt 3 550 308 House 6 1000 325 Apt 4 625 397 Apt 3 550 412 House 7 1250 441 Apt 2 475Explanation / Answer
2
None of the above(its a database software)
10
>Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.
why its important
>Normlization is important for DBMS because It is a process of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties
(1).Minimizing redundancy, (2). Minimizing insertion, deletion and update anomalies.
11
Four components
1)Data
The data stored in the system is partitioned into one of more database. A database is both integrated ans shared. By integrated we mean that the database may be thought as a unification of several otherwise distinct data files with any redundancy among those files partially or wholly eliminated.
By shared we mean that individual pieces of data in the database may be shared among several different users. In the sense that each of those users may have access to the same piece of data and may use it for different purposes.
2)Hardware
The hardware consists of the secondary storage volumes disks , drums etc. on which the database resides together with the associated devices, control units channels and so forth.
3)Software
Between the hardware and the user there is a layer of software, usually called the database management system (DBMS). All requests from the user for access to the database are handled by DBMS.
4)Users
There are three classes of user
a) Application Programmer
he application programmer is responsible for writing application programs that use the database typically in a language such as PL/1. These application programs operate on the data in all the usual ways retrieving information, creating new information, deleting of changing existing information. Functions are performed by issuing the appropriate requests to the DBMS.
b) End users
The second class of user is the end users accessing the database from a terminal. There are types of End user Casual user and Native user. Casual users are trained in the use of the online query language and access data by entering queries at terminals. Native users access data through application programs that have been written for them.They do not need to know any detail or the structure of language of the database system
c) DBA (Database Administrator)
DBA is a person of group of persons responsible fo overall control of database. The administrator needs both technical and managerial skills.
6)
True
4)
False
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.