Relational Database Systems

Key constraints specify that within each _tuple_, and the value of each attribute must be unique.

• True
• False

Programmers and database administrators work at this level, at this level data can be described as certain types of data records gets stored in data structures, however the internal details such as implementation of data structure is hidden at this level.

• PHYSICAL LEVEL

The name of the _Table_:

• EMPLOYEE

Databases are logically modelled clusters of information, or data. Any collection of data is a database, regardless of how or _where_ it is stored.

• True
• False

The relational model has provided the basis for:

• This is because duplicate data not only waste storage spaces but also easily lead to inconsistencies.
• Numerous database design methodologies
• The standard database access language called structured query language (SQL)
• Research on the theory of data/relationship/constraint

This should be specified when creating columns, that will dictate what kind of entries are allowed in that column.

• _DATA TYPE_

This keyword is used to compare strings, and it offers the feature that patterns containing wildcards can be used

• _LIKE_

Attribute, _Table_s, _Tuple_, Relation _Schema_, Degree, Cardinality, Column, Relation instance, are some important components of Relational Model

• True
• False

These operators takes the two sets and returns the values that are in the first set but not the second set.

• SET DIFFERENCE

SQL commands are divided into categories, the two main ones being Data Manipulation Language (DML) commands and Data Definition Language (DDL) commands. DDL commands deal with data, either retrieving it or modifying it to keep it up-to-date. DML commands create or change _table_s and other database objects such as views and indexes.

• True
• False

Integrity rules follow certain relational _table_s to ensure that the data they contain stay accurate and are always accessible

• True
• False

An entity that cannot be uniquely identified by its own attributes and relies on the relationship with other entity.

• WEAK ENTITY

An attribute can accept values that are outside of their domains.

• True
• False

The main advantages of relational databases are that they enable users to easily categorize and store data that can later be queried and filtered to extract specific information for reports.

• True
• False

Few relational databases have no limits on field lengths which can't be exceeded.

• True
• False

An attribute that can hold multiple values is known as multivalued attribute. It is represented with this geometric shape in an ER Diagram.

• _DOUBLE OVALS_

It is also know as each row of a _table_.

• RECORD

Database design is more art than science, as you have to make many decisions. Databases are usually customized to suit a particular application. Two customized applications are a_like_, and hence, two databases are a_like_.

• True
• False

This is the process of optimizing the database structure

• Primary keys
• Normalization
• Relations and attributes
• Relationships

It is a collection of data represented in rows and columns.

• _TABLE_

If low level access is allowed for the relational database, it should not be able to subvert the integrity constraints and bypass security to change the data.

• Rule 12: Nonsubversion Rule
• Rule 10: Integrity Independence
• Rule 9: Logical Data Independence
• Rule 8: Physical Data Independence
• Rule 11: Distribution Independence

In non-procedural query language, user instructs the system to perform a series of operations to produce the desired results. Here users tell what data to be retrieved from database and how to retrieve it.

• True
• False

There must be at least one set of attributes that can identify a _tuple_ in a unique manner.

• Referential Integrity constraints
• None of the above
• Domain constraints
• Key constraints

A distinguishing feature of relational databases is that it is possible to get data from more than one _table_ and this is what its called.

• _JOIN_

A hierarchical model represents the data in a tree-_like_ structure in which there are multiple parents for each record.

• True
• False

This model is one approach for organizing data that has found wide use in database software since it was first devised in the late 1960s.

• RELATIONAL MODEL

These are used to handle the data in the relational relational data model.

• _TABLE_S

These rules are applied to check whether your database is structurally correct and optimal.

• NORMALIZATION

There should be _insert_ion, deletion and updation possible in terms of a single operand. This facility must be available at all level of relations.

• Rule 5: Powerful and Well-Structured Language
• Rule 7: Quality _Insert_ion, _Update_, Deletion
• Rule 6:View Updation rule
• Rule 4: Dynamic Online Catalog

This model is used to represent real life scenarios as entities

Today, there are many commercial Relational Database Management System (RDBMS), such as Oracle, IBM DB2, and Microsoft SQL Lite Server. There are also many free and open-source RDBMS, such as MySQL, mSQL (mini-SQ ) and the embedded Java DB (Apache Derby).

• True
• False

This is the lowest level of data abstraction. It describes how data is actually stored in database. You can get the complex data structure details at this level.

• PHYSICAL LEVEL

This clause in a _SELECT_ statement provides the criteria for _select_ing values.

• _WHERE_

This statement specifies which columns to include in the _result set_.

• _SELECT_
• _DELETE_
• _INSERT_
• _UPDATE_

Intersection also adds all duplicates before displaying the result.

• True
• False

For any system to be qualified as a relational database management system, it should manage its data using its relational capability.

• Rule 1: Information rule
• Rule 0: Foundation rule
• Rule 3: Systematic treatment of Null values
• Rule 2: Guaranteed access rule

Highest level of data abstraction. This level describes the user interaction with database system.

• VIEW LEVEL

This is an attribute that is a combination of other attributes.

• COMPOSITE ATTRIBUTE

It is the smallest organizational structure of a relational database, and represents the various facets that define the records in the _table_.

• COLUMN

Relational calculus is a conceptual procedural query language used on relational model.

• True
• False

A relationship is represented by double diamond shape in ER diagram, it shows the relationship among entities. T

• True
• False

Total number of rows present in the _Table_.

• Column
• _Tuple_
• Degree
• Cardinality

A third aspect of data integrity involves the concept of a null value. A database takes care of situations _where_ data may not be available by using a null value to indicate that a value is missing. It does not equate to a blank or zero.

• True
• False

The relational data model was introduced introduced by C. F. Codd in 1980.

• True
• False

A __ of the database represents the same form of data.

• COLUMN

The rows that satisfy the conditions of a query are called this.

• _RESULT SET_

A blank is considered equal to another blank, a zero is equal to another zero, so two null values are considered equal.

• True
• False

In the late 1960s, this computer scientist working at IBM, devised the relational model of database management. His relational model allowed individual records to be associated with more than one _table_, thereby enabling “many-to-many” relationships between data points in addition to “one-to-many” relationships.

• EDGAR F. CODD

This relationship is also useful for storing certain sensitive data in a secure _table_, while the non-sensitive ones in the main _table_.

• ONE-TO-ONE

A composite attribute is one whose value is dynamic and derived from another attribute. It is represented by dashed oval in an ER Diagram.

• True
• False

This is a row of the _table_ and it stores the data details according to the _table_ _schema_.

• _TUPLE_

Referential Integrity Rule states that primary key cannot contain NULL. Otherwise, it cannot uniquely identify the row.

• True
• False

This relationship is, in fact, implemented as two one-to-many relationships, relationships, with the introduction of the junction _table_.

• MANY-TO-MANY

Itl is a design or blueprint of a database that can later be implemented as a database.

• ER MODEL

The data stored in database at a particular moment of time is called database _schema_.

• True
• False

This is a minimal set of attributes (columns) in a _table_ that uniquely identifies _tuple_s (rows) in that _table_.

• PRIMARY KEY

How the data stored in blocks of storage is described at this level.

• PHYSICAL _SCHEMA_

This is the middle level of 3-level data abstraction architecture. It describes what data is stored in database.

• LOGICAL LEVEL

RDBMSs often implement their own unique _data type_s, which may be directly interchangeable with similar _data type_s in other systems. Some common _data type_s include dates, strings, integers, and Booleans.

• True
• False

Advantages of Object Oriented Model are the following, except:

• It is easier to extend the design in Object Oriented Model.
• The object oriented model is quite flexible in most cases.
• This model can be quite complicated to create and understand.
• Due to inheritance, the _data type_s can be reused in different objects. This reduces the cost of maintaining the same data in multiple locations.

The advantages of the Object Relational model are the following, except:

• Complicated and difficult to handle at times
• Extensibility
• Complex _Data Type_s
• Inheritance

In relational model, the data and relationships are represented by collection of inter-related _table_s. Each _table_ is a group of column and rows, _where_ column represents attribute of an entity and rows represents records.

• True
• False

Relational algebra is a relational model query language used on conceptual procedural.

• True
• False

Relational database design mandates the use of a database server in applications for dealing with data management problems.

• True
• False

The following are the four types of attributes, except:

• Multivalued attribute
• Key attribute
• Decomposed attribute
• Composite attribute

Relational Integrity constraints is referred to conditions which must be present for a valid relation. These integrity constraints are derived from the rules in the mini-world that the database represents.

• True
• False

It is a set of one of more columns (attributes) to uniquely identify rows in a _table_.

• SUPER KEY

A relational attributes defines the _table_ name and its _schema_.

• True
• False

A Total participation of an entity set represents that each entity in entity set must have at least one relationship in a relationship set.

• True
• False

Database systems are made-up of complex data structures. To ease the user interaction with database, the developers shows internal irrelevant details from users.

• True
• False

Relational database design satisfies the ACID (atomicity, consistency, integrity, and disparity) properties required from a database design.

• True
• False

The following are the Best Practices for creating a Relational Model, except:

• Cells of the _table_ should hold a single value
• The relational model is easy as _table_s consisting of rows and columns is quite natural and simple to understand.
• Each column should be given a unique name
• Columns must contain data about attributes of the entity

This relationship cannot be represented in a single _table_.

• ONE-TO-MANY

It shows the relationship among entity sets.

• ER DIAGRAM

This database model is one of the early model, in which data are organized in a tree-_like_ structure, similar to modern-day filesystems.

• HIERARCHICAL MODEL

Referential integrity constraints is base on the concept of Foreign Keys. A primary key is an important attribute of a relation which should be referred to in other relationships

• True
• False

This combines two different results obtained by a query into a single result in the form of a _table_.

• _UNION_

It is a set of permitted values for an attribute in _table_.

• DOMAIN

It is for a _table_ is the attribute that can uniquely identify all the _tuple_s.

• KEY

These operators stores the values in two variables can be compared using following operators and n relation between them can be determined.

• RELATIONAL

A cursor can be thought of as a pointer into a file that contains the rows of the _result set_, and that pointer has the ability to keep track of which row is currently being accessed.

• True
• False

In terms of DBMS, an attribute is a _table_ or entity of a _table_ in database, so by showing relationship among _table_s and their entity, ER diagram shows the complete logical structure of a database.

• True
• False

In the relational model, each _table_ contains at least one column that can be used to uniquely identify each row, called a foreign key.

• True
• False

First, the rows in a relational _table_ should all be not distinct. If there are no duplicate rows, there can be problems resolving which of two possible _select_ions is the correct one.

• True
• False

Logical _Schema_ is the design of database at view level.

• True
• False

The design of a relational relational database is composed of four stages, _where_ the data are modeled into a set of related _table_s. The stages are the following except:

• Define primary keys
• Define relations/attributes
• Attributes
• Define relationships

This DDL command has the behavior of the implementation-defined when there are views or integrity constraints defined that reference the _table_ being dropped.

• _DROP _TABLE_

A second integrity rule of the traditional relational model is that column values must be repeating groups or arrays

• True
• False

It is the Design of a database.

• _SCHEMA_

The relational data model is the most famous data model and is used by the majority around he world. This is a simple but efficient data model and has the capability to handle data in the best possible manner.

• True
• False

When one user is accessing data in a database, another user can not be accessing the same data at the same time.

• True
• False

It is a set of one or more SQL statements that make up a logical unit of work.

• TRANSACTION

The following are the Four basic _update_ operations performed on relational database model, except:

• Merge
• _select_
• _delete_
• _Insert_