data models

Question 1

what data base design focuses on

Answer 1

how the database structure will be used to store and manage end user data

Question 2

what is the attribute

Answer 2

is characteristic of any entity

Question 3

what is the relationship

Answer 3

describes an association among entities

Question 4

what is the constraint

Answer 4

is a restriction placed on data constraint are important because they help to ensure data integrity

Question 5

what is business rule

Answer 5

is a brief precise and unambiguous description of a policy procedure or principle within a specific organization

Question 6

entity is noun
relationship is verb
true or false

Answer 6

true

Question 7

what is the segment

Answer 7

is the equivalent of a file system record type

Question 8

what is the schema

Answer 8

which is the conceptual organization of the entire database as viewed by the database administrator

Question 9

what is the subschema

Answer 9

which defines the portion of the database “seen”nby the application programs that actually produce the desired information from the data contained within the database

Question 10

what is the data management language (DML)

Answer 10

which defines the environment in which data can be managed and to work with the data in the database

Question 11

what is the schema data definition language (DDL)

Answer 11

which enable the database administrator to define the schema components

Question 12

in relational
every row is tuple
each column is attribute
true or false

Answer 12

true

Question 13

what is the file

Answer 13

a table with complete data and structural independence

Question 14

what is SQL

Answer 14

is structured query language

Question 15

what is the components of database application

Answer 15

user interface
a set of tables
stored in the database
and SQL ENGINE

Question 16

what is the SQL

Answer 16

is a declerative language that tell what must be done but not how it must be done

Question 17

what is the entity

Answer 17

anything about which data are to be collected and stored
rectangle
also known entity box

Question 18

what is the entity set

Answer 18

a collection of like entities

Question 19

what is the class

Answer 19

is a collection of similar objects with shared structure and the behavior

Question 20

what is the inheritance

Answer 20

is the ability of an object within the class hierarchy to inherit the attributes and the methods of the classes above

Question 21

what is unified modeling language

Answer 21

is a language based on OO concepts that describes a set of diagrams and symbols that can be used to graphically model a system