January 2021

1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, transaction-processing application. 2. What three main types of actions involve databases! Briefly discuss each.

1. Discuss the main characteristics of the database approach and how it differs from traditional file systems. 2. What are the responsibilities of the DBA and the database designers? 3. What are the different types of database end users? Discuss the main activities of each. 4. Discuss the capabilities that should be provided by a

1. Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2. 2. What is the difference between controlled and uncontrolled redundancy? Illustrate with examples. 3. Name all the relationships among the records of the database shown in Figure 1.2.4. Give some additional views that may

1.Cite some examples of integrity constraints that you think should hold on thedatabase shown in Figure 1.2. 2.1. Define the following terms: data model, database schema, database state, internal schema, conceptual schema, external schema, data independence, DOL, OML, SOL, VOL, query language, host language, data sublanguage, database utility, catalog, client/ server architecture. Discuss the main

1.What is the difference between logical data independence and physical data independence? 2. What is the difference between procedural and nonprocedural DMLs? 3. Discuss the different types of user-friendly interfaces and the types of users who typically use each. 4. With what other computer system software does a DBMS interact?

1.What is the difference between the two-tier and three-tier client/server architectures? 2. Discuss some types of database utilities and tools and their functions. 3. Think of different users for the database of Figure 1.2. What types of applications would each user need? To which user category would each belong, and what type of interface would

What is a subclass? When is a subclass needed in data modeling? Define the following terms: superclass of a subclass, superclass/subclass relationship, is-a relationship, specialization, generalization, category, specific (local) attributes) specific relationships. 3. Discuss the mechanism of attribute/relationship inheritance. Why is it useful? Discuss user-defined and predicate-defined subclasses, and identify the differences between the two.

1.Discuss user-defined and attribute-defined specializations, and identify the differences between the two. 2. Discuss the two main types of constraints on specializations and generalizations. 3. What is the difference between a specialization hierarchy and a specialization lattice? 4. What is the difference between specialization and generalization? Why do we not display this difference in schema

How does a category differ from a regular shared subclass? What is a category usedfor? Illustrate your answer with examples. 2. For each of the following UML terms (see Sections 3.8 and 4.6), discuss the corresponding term in the EERmodel, if any: object, class, association, aggregation, generalization, multiplicity, attributes, discriminator, link, link attribute, reflexive association,

See instructions below “Public health paper”   Paper details: Health Problem Topic: National kidney Foundation 1. Evaluate public health and prevention strategies for important health problems 2. Identify the roles of law and government public health agencies in promoting and protecting the health of the public; and, practice planning, implementing, and evaluating public health interventions.