All Matches
Solution Library
Expert Answer
Textbooks
Search Textbook questions, tutors and Books
Oops, something went wrong!
Change your search query and then try again
Toggle navigation
FREE Trial
S
Books
FREE
Tutors
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Ask a Question
Search
Search
Sign In
Register
study help
computer science
database concepts
Questions and Answers of
Database Concepts
If you haven?t done so, create the WPC database, tables, and relationships described in this chapter, using the SQL DBMS of your choice. Be sure to populate the tables with the data shown in Figure
Write an ALTER TABLE statement to add a CHECK constraint to the ENROLLMENT table to ensure that the value of FullFeePaid is either Yes or No.
Write a set of SQL statements (Hint: Use the SQL ALTER TABLE command.) to add a FullFeePaid column to ENROLLMENT and populate the column, assuming that the column is NOT NULL. The only possible
Write a set of SQL statements (Hint: Use the SQL ALTER TABLE command.) to add a FullFeePaid column to ENROLLMENT and populate the column, assuming that the column is NULL. The only possible values
Modify your query to include all students, regardless of whether they registered in Adv. Pastels, starting on October 1, 2015. Include, in this order, CustomerLastName, CustomerFirstName, Phone,
Write and run an SQL query to list all students registered in Adv. Pastels starting on October 1, 2015. Include in this order, Course, CourseDate, CustomerLastName, CustomerFirstName, Phone, Fee, and
Write and run an SQL query to list all students registered in Adv. Pastels starting on October 1, 2013. Include, in this order, the Course, CourseDate, Fee, CustomerLastName, CustomerFirstName, and
Write and run an SQL query to list all students and courses they are registered for. Include, in this order, CustomerNumber, CustomerLastName, CustomerFirstName, Phone, CourseNumber, and AmountPaid.
Write and run an SQL query to list all occurrences of Adv. Pastels. Include all associated data for each occurrence of the class.
For Access, Oracle Database and MySQL: See the solutions to Review Question 3.41 for comments on modifying the data shown below for SQL Server 2014 for data inserts in Microsoft Access, Oracle
Write and run the SQL statements necessary to create the tables and their referential integrity constraints.For the database solutions for the Review Questions about the Art-Course-Database, see the
Write an SQL statement to drop the PetWeight column you added to the PET table in either question 3.47 or 3.49. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID,
Write an SQL statement to add a CHECK constraint to the PET table so that the weight data recorded in the PetWeight column you added to the table in either question 3.47 or 3.49 is less than
Write SQL statements to add a PetWeight column like the one in PET_3 to the PET table, given that this column is NOT NULL. Again, assume that PetWeight is Numeric(4,1). Use the PetWeight data from
Write SQL statements to insert data into the PetWeight column you created in question 3.47. Use the PetWeight from the PET_3 table. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone,
Write an SQL statement to add a PetWeight column like the one in PET_3 to the PET table, given that this column is NULL. Again, assume that PetWeight is Numeric(4,1). PET_OWNER (OwnerID,
Write an SQL statement to delete all rows of pets of type Anteater. What will happen if you forget to code the WHERE clause in this statement? PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName,
Explain what will happen if you leave the WHERE clause off your answer to question 3.44. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType,
Write an SQL statement to change the value of Std. Poodle in BreedName of PET_3 to Poodle, Std. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName,
Write an SQL statement to add three new rows to the PET_OWNER table. Assume that OwnerID is a surrogate key and that the DBMS will provide a value for it. Assume, however, that you have only
Write a SQL statement to add three new rows to the PET_OWNER table. Assume that OwnerID is a surrogate key, and that the DBMS will provide a value for it.Use the first three lines of data provided in
Write an SQL statement to display the OwnerLastName, OwnerFirstName, PetName, PetType, PetBreed, and AverageLifeExpectancy for pets with a known PetBreed. PET_OWNER (OwnerID, OwnerLastName,
Answer part (4) of question 3.37, but use joins using JOIN ON syntax.? PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed,
Answer question 3.36, but use a join using JOIN ON syntax. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed, PetDOB,?OwnerID)
Answer question 3.35, but use a join using JOIN ON syntax. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed, PetDOB,?OwnerID) FIGURE
Write SQL Statements to (1) create the BREED table, (2) insert the data in Figure3-20 into the BREED table, (3) alter the PET_3 table so that PetBreed is a foreign key referencing BreedName in BREED,
Write an SQL statement to display the last name, first name, and email of any owners of cats with the name Teddy. Use a subquery. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone,
Write an SQL statement to display the last name, first name, and email of any owners of cats. Use a subquery. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID,
Answer question 3.33, but do not consider any pet having the PetBreed value of Unknown. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType,
Answer question 3.32, but consider only breeds for which two or more pets are included in the database. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName,
Write an SQL statement to group the data by PetBreed and display the average Weight per breed. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType,
Write an SQL statement to display the minimum, maximum, and average weight of dogs. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed,
Write the required SQL statements to create the PET_3 table. Assume that PetWeight is Numeric(4,1). PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName,
Write an SQL statement to count the number of distinct breeds. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed, PetDOB,?OwnerID)
Write an SQL statement to count the number of pets. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed, PetDOB,?OwnerID) FIGURE 3-18|
Write a SQL statement to display the name and breed of all pets sorted by PetBreed in ascending order and by PetName in descending order within PetBreed. PET_OWNER (OwnerID, OwnerLastName,
Write an SQL statement to display the name and breed of all pets sorted by PetName. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed,
Write an SQL statement to display the lastname, firstname and email of any owner who has a NULL value for OwnerPhone. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET
Write a SQL statement to display the lastname, firstname and email of all owners who have an email address ending with somewhere.com. Assume that email account names can be any number of
Write an SQL statement to display the PetID, breed, and type for all pets having a four-character name starting with K. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET
Write a SQL statement to display the name, breed, and type for all pets that are not of type Cat, Dog, or Fish. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID,
Write a SQL statement to display the breed, type, and DOB for all pets having the type Dog and the breed Std. Poodle. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET
Write a SQL statement to display the PetBreed column of PET. Do not show duplicates. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed,
Write an SQL statement to display the PetBreed column of PET. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed, PetDOB,?OwnerID)
Write a SQL statement to display the breed, type, and DOB of all pets having the type Dog. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType,
Write a SQL statement to display the breed and type of all pets. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed, PetDOB,?OwnerID)
PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed, PetDOB,?OwnerID) FIGURE 3-18| PET_OWNER Data OwnerID OwnerLastName OwnerFirstName
Write a SQL statement to display all columns of all rows of PET. Do not use the asterisk (*) notation. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName,
Write the SQL statements necessary to remove the PET_OWNER table from the database. Assume that the PET table is to be removed.?Do not run these commands in an actual database! PET_OWNER (OwnerID,
1Write the SQL statements necessary to remove the PET_OWNER table from the database. Assume that the referential integrity constraint is to be removed. Do not run these commands in an actual
1Is PET or PET_2 a better design? Explain your rationale. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed, PetDOB,?OwnerID) FIGURE
Write the required SQL statements to create the PET_2 table. PET_2 (PetName, PetType, PetBreed, PetDOB, OwnerID) PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID,
Create a referential integrity constraint on OwnerID in PET. Assume that deletions should cascade PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName,
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.
Showing 1 - 100
of 650
1
2
3
4
5
6
7