Questions and Answers of Database Concepts

Use MySQLand the MySQL Workbench to run one or more of the saved SQL queries you created in question C.24:
The MySQL Workbench creates “database models.” What is a data model? What is a database design? Which does MySQL Workbench create?
How do you create a database model in MySQL Workbench?
How do you create a new E-R diagram in the MySQL Workbench?
How do you create a table in an E-R diagram?
How do you create a 1:N non-identifying relationship in an E-R diagram?
How does the MySQL Workbench handle N:M relationships?
If you haven’t already done so, download and install MySQL 5.6 Community Server Edition and the MySQL Workbench. Use the default settings for each installation. When you are asked for a password
What is a statement of work (SOW)? What purpose does it serve?
What is a user requirements document (URD)? What purpose does it serve?
What is a use case? How well does Microsoft Visio 2010 support modeling use cases?
Define project scope.
What is business process modeling notation (BPMN)? How well does Microsoft Visio 2010 support BPMN?
Describe the systems development life cycle (SDLC) model.
What is systems analysis and design?
What is business process modeling?
Describe how information systems include processes.
How do information systems support business processes?
Describe Michael Porter’s support activities.
Describe Michael Porter’s primary activities.
What is a decision?
What is data?
What is information?
What is a computer-based information system? Describe the five components of a computer-based information system.
What is a competitive strategy?
Create a copy of the WPC-Data-Model.vsd file, and name it WPC-Data-Model-with-ASSIGNMENT.vsd. Modify the data model to include the ASSIGNMENT as shown in the SQL statements in Figure G-8.
The data model for Heather Sweeney Designs is shown in Figure 4-20(c). In Microsoft Visio 2013, create a new Database Model Diagram drawing named HSD-Data-Model. Recreate the data model shown in
Why is the material in this appendix important?
What utility is used to manage IIS?
What utility is used to manage ODBC?
How do you add a program icon to the Windows 8 Taskbar?
How is the file system that supports IIS structured?
Briefly describe how to view a Web page that has been created in the IIS Web server.
What are Windows security permissions?
Briefly describe how to manage Windows security permissions.
Briefly describe how to install the JDK.
What is the NetBeansIDE?
What is the Java Software Development Kit (JDK)? Why is it needed for the NetBeans IDE?
Develop a graph database based on the WPC EMPLOYEE and PROJECT tables. Data form the ASSIGNMENT table should appear as edge properties
What is the purpose of PHP dynamic extension *.dll files?
What are the Microsoft Drivers for PHP for SQL Server?
Using the Microsoft Drivers for PHP for SQL Server as an example, briefly describe how to install and enable additional PHP dynamic extension *.dll files to an existing PHP installation.
What are the three sources of data for BI systems?
What is an ETL system, and what functions does it perform?
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.
Explain the difference between a data warehouse and a data mart. Give an example other than the ones used in this book.
In RFM analysis, what do the letters RFM stand for?
Explain the characteristics of customers that have the following RFM scores:{1 1 5}, {1 5 1}, {5 5 5}, {2 5 5}, {5 1 2}, {1 1 3}
Name and describe the purpose of the major components of a reporting system.
What are the major functions of a reporting system?
Summarize the types of reports described in this chapter.
Describe the various media used to deliver reports.
Summarize the modes of reports described in this chapter.
Describe the major tasks in report management. Explain the role of report metadata in report management.
Name three tasks of report authoring.
Describe the major tasks in report delivery.
Define data mining.
Explain the difference between unsupervised and supervised data mining.
Name five popular data mining techniques.
What is the probability that someone will buy a tank? Mask Fins Weights Tank Dive Computer 1,000 Transactions 270 280 120 200 130 Mask 150 20 20 20 50 Tank 20 80 40 30 30 Fins 150 40 10 60 20 20
What is the support for buying a tank and fins? What is the support for buying two tanks?
What is the confidence for fins, given that a tank has been purchased?
What is the confidence for a second tank, given that a tank has been purchased?
What was the first nonrelational data store to be developed, and who developed it?
As illustrated in Figure K-5, what is column family database storage and how are such systems organized? How do column family database storage systems compare to RDBMS systems?
What are the problems in interpreting tags such as < h1 >…< / h1 > in HTML?
How does XML differ from HTML?
Explain why XML is extensible.
What is a DTD, and what purpose does it serve?
What is the difference between a well-formed XML document and a type-valid XML document?
What is the purpose of an XML Schema document?
How does an XML Schema document differ from a DTD?
What is a schema-valid document?
How is an XML document validated?
How is an XML Schema document validated?
Explain an advantage of automated schema validation.
Explain the difference between simple and complex elements.
Explain the difference between XML elements and attributes.
What is a general rule for using elements and attributes to represent database data?
In general terms, explain why XML is important for database processing.
What is graph database? What are nodes, properties and edges?
Develop an XML Schema for a document that uses the data in the HSD SEMINAR, SEMINAR_CUSTOMER, and CUSTOMER tables. If you need more information about XML Schema, go to W3C and read tutorials on XML
Why is the relational model important?
What does SQL stand for, and what purpose does it serve?
Summarize the differences between the database systems in Figures 1-23 and 1-26.
Show how the tables you created for question 1.12 solve the three problems of lists identified in this chapter.
Why are the values of surrogate keys normally hidden from users on forms, queries, and reports?
Explain how primary keys and foreign keys are denoted in this book.
Define the term referential integrity constraint and give an example of one.
Explain three possible interpretations of a null value.
Give an example of a null value (other than one from this chapter), and explain each of the three possible interpretations for that value.
Define the terms functional dependency and determinant, using an example not from this book.
Explain the meaning of the following expression:
Define the term primary key in terms of functional dependencies.
If you assume that a relation has no duplicate data, how do you know there is always at least one primary key?
In your own words, describe the nature and purpose of the normalization process.
Using the assumptions you stated in your answer to question 2.32, what are the determinants of this relation? What attribute(s) can be the primary key of this relation?
Examine the data in the Veterinary Office List—Version Two in Figure 1-31 (see page 55), and state assumptions about functional dependencies in that table.
Using the assumptions you stated in your answer to question 2.35, what are the determinants of this relation? What attribute(s) can be the primary key of this relation?

Showing 200 - 300 of 650