Questions and Answers of Database Concepts

Create a referential integrity constraint on OwnerID in PET. Assume that deletions should not cascade. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName,
Write a SQL CREATE TABLE statement to create the PET tablewithout a referential integrity constraint on OwnerID in PET. Justify your choices of column properties. Why not make every column NOT
Write a SQL CREATE TABLE statement to create the PET_OWNER table, with OwnerID as a surrogate key. Justify your choices of column properties. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName,
Why do some standard SQL-92 statements fail to run successfully in Microsoft Access?
Describe in your own words the purpose of the two business rules listed on page 114.
Why is it important to learn SQL?
Explain the importance of SQL-92.
What is a data sublanguage?
What does SQL stand for?
The Queen Anne Curiosity Shop sells both antiques and current-production household items that complement or are useful with the antiques. For example, the store sells antique dining room tables and
The James River Jewelry Project Questions are available online for Appendix D, which can be downloaded from the textbook?s Web site: www.pearsonhighered.com/kroenke. The solutions for these questions
Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and
Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-33 shows data that Regional Labs collects about projects and
Consider a table named ORDER_ITEM, with data as shown in Figure 2-26. The schema for ORDER_ITEM is: ORDER_ITEM (OrderNumber, SKU, Quantity, Price) Where SKU is a ?Stocking Keeping Unit? number,
Alter question 2.40 to allow students to have multiple majors. In this case, the relational structure is:STUDENT (StudentNumber, StudentName, SiblingName, Major)A. Show an example of this relation
Apply the normalization process to the Veterinary Office List—Version Two relation shown in Figure 1-31 to develop a set of normalized relations. Show the results of each of the steps in the
Apply the normalization process to the Veterinary Office List—Version One relation shown in Figure 1-30 to develop a set of normalized relations. Show the results of each of the steps in the
Explain a modification problem that occurs when changing data in the relation in question 2.35 and a second modification problem that occurs when deleting data in this relation.
Describe a modification problem that occurs when changing data in the relation in question 2.32 and a second modification problem that occurs when deleting data in this relation.
Examine the data in the Veterinary Office List—Version One in Figure 1-30 (see page 52), and state assumptions about functional dependencies in that table. What is the danger of making such
How does your answer to question 2.29 change if you allow a relation to have duplicate data?
Explain the differences in your answers to questions 2.25 and 2.26.
Explain the meaning of the following expression:
In the following equation, name the functional dependency and identify the determinant(s):
Explain the term foreign key and give an example.
How do surrogate keys obtain their values?
The Queen Anne Curiosity Shop sells both antiques and current-production household items that complement or are useful with the antiques. For example, the store sells antique dining room tables and
Use a Web browser to find three examples of static Web pages and three examples of dynamic Web pages, and note the URLs for each page you find. Explain the purpose of each page and why you believe it
Using a document at your own school (for example, a class schedule), determine the attributes present in the document. Using your knowledge of the policies at your school, determine the functional
Design a survey form of your own. Fill it out as it might have been completed during the database design forHenry Books. For any questions you have too little information to answer, make a reasonable
Give an example of a column A and a column B such that B is functionally dependent on A. Give an example of a column C and a column D such that D is not functionally dependent on C.
Explain how OO concepts affect database design. How does the OO environment affect the DBA's role?
What are the advantages and disadvantages of an OODBMS?
Name and describe the 13 mandatory features of an OODBMS.
ROBCOR, a medium-sized company, has decided to update its computing environment. ROBCOR has been a minicomputer-based shop for several years, and all of its managerial and clerical personnel have
Describe the difference between early and late binding. How does each of those affect the object-oriented data model? Give examples.
What are the five minimum attributes of an OO data model?
Explain the concept of abstract data types. How they differ from traditional or base data types? What is the relationship between a type and a class in OO systems?
Define and explain the concepts of method overriding and polymorphism. Use examples in your explanations.
Modify the insert scripts (rc-5a.cfm and rc-5b.cfm) for the DEPARTMENT table so the users who can be manager of a department are only those who belong to that department.
Define the concepts of class hierarchy, superclasses, and subclasses. Explain the concept of inheritance and the different types of inheritance. Use examples in your explanations.
Create ColdFusion scripts to search, add, edit, and delete records for the VENDOR table in the RobCor database.
What is a class protocol, and how is it related to the concepts of methods and classes? Draw a diagram to show the relationship between these OO concepts: object, class, instance variables, methods,
Create ColdFusion scripts to search, add, edit, and delete records for the INVTYPE table in the RobCor database.
Using an example, illustrate the concepts of class and class instances.
Create ColdFusion scripts to search, add, edit, and delete records for the USER table in the RobCor database.
Define and contrast the concepts of method and message. What OO concept provides the differentiation between a method and a message? Give examples.
Define and describe the following:a. Objectb. Attributesc. Object stated. Object ID
Discuss the evolution of object-oriented concepts. Explain how those concepts have affected computer-related activities.
In Oracle, what is a tablespace?
What is the tool used by Oracle to create users?
How have cloud-based data services affected the DBA’s role.?
Identify and explain some of the critical success factors in the development and implementation of a good data administration strategy.
Briefly explain the concepts of information engineering (IE) and information systems architecture (ISA). How do these concepts affect the data administration strategy?
What characteristics do a CASE tool and a DBMS have in common? How can these characteristics be used to enhance the data administration?
Using SQL statements, give some examples of how you would use the data dictionary to monitor the security of the database.
Define the concept of a data dictionary, and discuss the different types of data dictionaries. If you were to manage an organization's entire data set, what characteristics would you look for in the
What are security vulnerabilities? What is a security threat? Give some examples of security vulnerabilities that exist in different IS components.
What are the levels of data confidentiality?
Identify some bottlenecks in DBMS performance, and then propose some solutions used in DBMS performance tuning.
Why are testing and evaluation of the database and applications not done by the same people who are responsible for the design and implementation? What minimum standards must be met during the
Describe the activities that are typically associated with the design and implementation services of the DBA technical function. What technical skills are desirable in the DBA's personnel?
Assume that your company assigned you the responsibility of selecting the corporate DBMS. Develop a checklist for the technical and other aspects involved in the selection process.
Discuss the importance and characteristics of database data backup and recovery procedures. Then describe the actions that must be detailed in backup and recovery plans.
Protecting data security, privacy, and integrity are important database functions. What activities are required in the DBA's managerial role of enforcing these functions?
Explain the DBA's managerial role in the definition and enforcement of policies, procedures, and standards.
What DBA activities are used to support end users?
What are the DBA's managerial roles? Describe the managerial activities and services provided by the DBA.
Describe and characterize the skills desired for a DBA.
Explain how the DBA plays an arbitration role for an organization's two main assets. Draw a diagram to facilitate your explanation.
Explain and contrast the differences and similarities between the DBA and DA.
Explain the DBA department's internal organization, based on the DBLC approach.
Describe and contrast the information needs at the strategic, tactical, and operational levels in an organization. Use examples to explain your answer.
Create a sample XML document and DTD for the exchange of student transcript data. Use your college transcript as a sample.
As a discipline As a discipline, data visualization can be studied as _a group of visual communication techniques used to explore and discover data insights by applying: pattern recognition, spatial
What is data replication, and what are the three replication strategies?
Describe the three data fragmentation strategies. Give some examples of each.
Explain the need for the two-phase commit protocol. Then describe the two phases.
Define and explain the different types of distribution transparency.
List and explain the transparency features of a DDBMS.
What are the components of a DDBMS?
What is a fully distributed database management system?
Explain the difference between distributed database and distributed processing.
What are the disadvantages of the DDBMS?
What are the advantages of the DDBMS?
List and discuss some of the factors that influenced the evolution of the DDBMS.
Describe the evolution from centralized DBMSs to distributed DBMSs.
A table is in ___3rd___ normal form when it is in ___2nd normal form___ and there are no transitive dependencies.
How do you connect to a database in Oracle Database Express Edition 11g Release 2?
What file extension should you use for SQL scripts?
Create a Web page for Heather Sweeney Designs to display data in the SEMINAR,SEMINAR_CUSTOMER, and CUSTOMER tables to list the SEMINARdata and the EmailAddress, LastName, FirstName, and Phone of any
Code two HTML/PHP pages to add a new CUSTOMER to the HSD database. Create data for two new CUSTOMERs and add them to the database to demonstrate that your pages work.
A. You need about 20 SERVICE transactions in the database. Write the needed SQL statements for any needed additional SERVICE transactions and insert the data into your database.B. Design a data
A. Design a data warehouse star schema for a dimensional database named JRJ-DW. The fact table measure will be Retail Price.B. Create the JRJ-DW database in a DBMS product.C. What transformations of
A. Design a data warehouse star schema for a dimensional database named QACS-DW. The fact table measure will be Item Price.B. Create the QACS-DW database in a DBMS product.C. What transformations of
What are the three sources of data for BI systems?
What problems in operational data create the need to clean data before loading the data into a data warehouse
What does it mean to transform data? Give an example other than the ones used in this book.
What is the enterprise data warehouse (EDW) architecture?
Explain two ways that the OLAP report in Figure 8-18 differs from that in Figure 8-17.

Showing 100 - 200 of 697