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

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

Answer 16

Cardinality

Question 17

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

Answer 17

Entity-Relationship model

Question 18

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 18

Entity

Question 19

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 19

Relationship

Question 20

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

Answer 20

Entities

Question 21

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

Answer 21

Attributes

Question 22

represented by ellipses that are connected with an ellipse

Answer 22

Composite Attributes

Question 23

attributes are depicted by dashed ellipse

Answer 23

Derived

Question 24

ttributes are depicted by double ellipse.

Answer 24

Multivalued

Question 25

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

Answer 25

Simple attribute

Question 26

are made of more than one simple attribute.

Answer 26

Composite attribute

Question 27

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

Answer 27

Derived attribute

Question 28

-value attributes contain single value.

Answer 28

Single-value attribute

Question 29

Multi-value attributes may contain more than one values

Answer 29

Multi-value attribute

Question 30

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

Answer 30

Super Key

Question 31

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

Answer 31

Candidate Key

Question 32

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

Answer 32

Primary Key

Question 33

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 33

Super Key

Question 34

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

Answer 34

Candidate Key

Question 35

super key with no repeated attributes

Answer 35

Candidate Key

Question 36

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

Answer 36

Primary Key