Database Modelling Quiz
ACSG 552 – 01.
Processor Florence Appel
Advanced Database Class- Spring 2009.
Assignment #01.
Friday, January 23, 2009
Due in class on Thursday, Jan. 22.
o Chapter 2 ▪ Review Questions, pp. 54-55: 2, 5, 6, 9, 18, 19 ▪ Problems, pp. 55-59: 1, 2; 12-15; 19-21; 22; 25abcde
Chapter 02:
Review Questions: pp. 54-55.
#02) What is a business rule, and what is its purpose in data modeling?
The business rule is a brief, precise and ambiguous description of a policy, procedure, or principle within a specific organization business rules apply to every organization, and uses data and generates more data.
Data modeling: Relatively simple representation, usually graphical, of more complex real world date structures. Data Modeling is in effect a blueprint contaminating all the instructions to build a database that will melt all end, user requirements. Data modeling clarifies such communication by reducing the complexities database design, to more easily understand abstraction that define entities and the relations among them.
#05) What three languages were adopted by the DBTG to standardize the basic network data model, and why was such standardization important for users and designers?
-Data management language (DML).
-Data deviation language (DDL).
-SQL, data manipulation language to work the data in the data in the database.
-To help establish database standards.
-Make standards specifications.
-Distinct components for databases.
#06) Describe the basic of the features of the relational data model and discuss their importance to the end user and designer?
• Automatic transformation, to create a database revolution. • Database relations work on by describing precise, set of data manipulation constructs, based on new advanced concepts. • Relational model has all the basic functions from previous versions of database, plus more functionalities now. • In addition more
Processor Florence Appel
Advanced Database Class- Spring 2009.
Assignment #01.
Friday, January 23, 2009
Due in class on Thursday, Jan. 22.
o Chapter 2 ▪ Review Questions, pp. 54-55: 2, 5, 6, 9, 18, 19 ▪ Problems, pp. 55-59: 1, 2; 12-15; 19-21; 22; 25abcde
Chapter 02:
Review Questions: pp. 54-55.
#02) What is a business rule, and what is its purpose in data modeling?
The business rule is a brief, precise and ambiguous description of a policy, procedure, or principle within a specific organization business rules apply to every organization, and uses data and generates more data.
Data modeling: Relatively simple representation, usually graphical, of more complex real world date structures. Data Modeling is in effect a blueprint contaminating all the instructions to build a database that will melt all end, user requirements. Data modeling clarifies such communication by reducing the complexities database design, to more easily understand abstraction that define entities and the relations among them.
#05) What three languages were adopted by the DBTG to standardize the basic network data model, and why was such standardization important for users and designers?
-Data management language (DML).
-Data deviation language (DDL).
-SQL, data manipulation language to work the data in the data in the database.
-To help establish database standards.
-Make standards specifications.
-Distinct components for databases.
#06) Describe the basic of the features of the relational data model and discuss their importance to the end user and designer?
• Automatic transformation, to create a database revolution. • Database relations work on by describing precise, set of data manipulation constructs, based on new advanced concepts. • Relational model has all the basic functions from previous versions of database, plus more functionalities now. • In addition more