2

Question 1

used by various users for various purposes

Answer 1

DBMS

Question 2

can be seen as single tier or multi tier or n-tier architecture

Answer 2

DBMS Architecture

Question 3

It does not provide handy tools for end users and preferably database designer and programmers use single tier architecture

Answer 3

DBMS/1 Tier Architecture

Question 4

must have some application, which uses the DBMS

Answer 4

2-tier Architecture

Question 5

separates it tier from each other on basis of users

Answer 5

3-tier architecture

Question 6

tells how the logical structure of a database is modeled

Answer 6

Data Model

Question 7

are fundamental entities to introduce abstraction in DBMS

Answer 7

Data Model

Question 8

define how data is connected to each other and how it will be processed and stored inside the system

Answer 8

Data Model

Question 9

Goal– make sure all data objects required by a database are completely and accurately represented

Answer 9

Data Modeling

Question 10

precise description of the data content in a system

Answer 10

Data Model

Question 11

Design the database at physical, logical and view level

Answer 11

Data Model

Question 12

represents the nature of data, and the business logic to control the data. It is also organize the database

Answer 12

Data Modeling

Question 13

helps to communicate between business people, who requires the computer system, and the technical people who can fulfill their requirements.

Answer 13

Data Modeling

Question 14

a class of real world objects having common attributes (e.g., sites, variables, methods).

Answer 14

Entity

Question 15

A characteristic or property of an entity (site name, latitude, longitude)

Answer 15

Attribute

Question 16

An association between two or more entities

Answer 16

Relationship

Question 17

the number of entities on either end of a relationship (one-to-one, one-to- many, many-to-many, etc.)

Answer 17

Cardinality

Question 18

based on the notion of real world entities and relationship among them

Answer 18

Entity-Relationship model

Question 19

in ER model is real world entity, which has some properties called attributes. Every attribute is defined by its set of values called domain

Answer 19

Entity

Question 20

The logical association among entities is called. are mapped with entities in various ways. Mapping cardinalities define the number of association between two entities.

Answer 20

Relationship

Question 21

represented by means of rectangles. Rectangles are named with the entity set they represent.

Answer 21

Entities

Question 22

the properties of entities. are represented by means of ellipses. Every ellipse represents one attribute and is directly connected to its entity (rectangle).

Answer 22

Attributes

Question 23

represented by ellipses that are connected with an ellipse

Answer 23

Composite Attributes

Question 24

attributes are depicted by dashed ellipse

Answer 24

Derived

Question 25

attributes are depicted by double ellipse.

Answer 25

Multivalued

Question 26

atomic values, which cannot be divided further. For example, a student’s phone number is an atomic value of 10 digits

Answer 26

Simple attribute

Question 27

are made of more than one simple attribute.

Answer 27

Composite attribute

Question 28

the attributes that do not exist in the physical database, but their values are derived from other attributes present in the database.

Answer 28

Derived attribute

Question 29

-value attributes contain single value.

Answer 29

Single-value attribute

Question 30

Multi-value attributes may contain more than one values

Answer 30

Multi-value attribute

Question 31

A set of attributes (one or more) that collectively identifies an entity in an entity set.

Answer 31

Super Key

Question 32

A minimal super key is called a candidate key. An entity set may have more than one candidate key

Answer 32

Candidate Key

Question 33

is one of the candidate keys chosen by the database designer to uniquely identify the entity set.

Answer 33

Primary Key

Question 34

group of single or multiple keys which identifies rows in a table. A Super key may have additional attributes that are not needed for unique identification

Answer 34

Super Key

Question 35

is a set of attributes that uniquely identify tuples in a table

Answer 35

Candidate Key

Question 36

super key with no repeated attributes

Answer 36

Candidate Key

Question 37

column or group of columns in a table that uniquely identify every row in that table

Answer 37

Primary Key