Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
How are comments designated in HTML code? What is an Integrated Development Environment (IDE), and how is it used?
What is the Eclipse PDT Project? Show a snippet of PHP code for creating a recordset. Explain the meaning of the code.
Create an appropriate ODBC data source for your database. Code a Web page using PHP to display the data in PROPERTY.
Create a user named GG-User with the password GG-User+password. Assign this user to database roles so that the user can read, insert, delete, and modify data.
Prepare a database in your DBMS named MDC, and use the MDC SQL scripts for your DBMS to create and populate the database tables.
Create a Web page for Heather Sweeney Designs to display the data in the SEMINAR_CUSTOMER table for the SEMINAR with SeminarID = 3.
Create a Web page for Heather Sweeney Designs to display the EmailAddress, LastName, FirstName, and Phone of customers in the CUSTOMER table.
In general terms, explain why XML is important for database processing. What is the purpose of the FOR XML expression in an SQL statement?
What are the problems in interpreting tags such as ... in HTML? What does XML stand for? How does XML differ from HTML? Explain why XML is extensible.
Show a snippet of PHP code for disconnecting from the database. Explain the meaning of the code. With respect to HTTP, what does stateless mean?
How do BI systems differ from transaction processing systems? Name and describe the two main categories of BI systems.
What problems in operational data create the need to clean data before loading the data into a data warehouse?
Explain the difference between a data warehouse and a data mart. What is the enterprise data warehouse (EDW) architecture?
Describe the differences between operational databases and dimensional databases. What is a fact table? What type of data are stored in fact tables?
What is a slowly changing dimension? Why is the time dimension important in a dimensional model? What is a conformed dimension?
What does OLAP stand for? What is the distinguishing characteristic of OLAP reports? Define measure, dimension, and cube.
Explain what must be done when fully replicating a database but allowing only one computer to process updates.
What organizations should consider using a distributed database? Explain the meaning of the term object persistence.
What is an object-relational database? What is Big Data? What is the relationship between 1 MB of storage and 1EB of storage?
What is the NoSQL movement? What were the first two nonrelational data stores to be developed, and who developed them?
Explain MapReduce processing. What is Hadoop, and what is the history of the development of Hadoop to its current state? What are HBase and Pig?
Create a database in your DBMS named MDC, and use the MDC SQL scripts for your DBMS to create and populate the database tables.
What is an associative entity? What is an association relationship? Give an example of an association relationship other than one shown in this text.
Give an example of a supertype-subtype relationship, other than one shown in this text. Illustrate your answer using an IE Crow's Foot E-R diagram.
Describe how you have represented weak entities, if any exist. Describe how you have represented supertype and subtype entities, if any exist.