Questions and Answers of Database Concepts

Design (through the logical phase) a student advising system that will enable an advisor to bring up the student's complete performance record at the university. A sample output screen should look
Convert the following relational database tables to the equivalent OO conceptual representation. Explain each of your conversions with the help of a diagram.
Using the tables in Figure PG.1 as a source of information:a. Define the implied business rules for the relationships.b. Using your best judgment, choose the type of participation of the entities in
Using the data presented in Problem 1, develop an object space diagram representing the object's state for the instances of TRUCK listed below. Label each component clearly with proper OIDs and
Given the information in Problem 1, define a superclass VEHICLE for the TRUCK class. Redraw the object space you developed in Problem 3, taking into consideration the new superclass that you just
How is a relationship between entities indicated in an ERD? Give an example, using the Crow’s Foot notation.
Using a simple example, explain the use of binary and shared/exclusive locks in a DBMS.
How do you normally define security? How is your definition of security similar to or different from the definition of database security in this chapter?
Verify the conceptual model you created in Appendix B, Problem 5. Create a data dictionary for the verified model.
Verify the conceptual model you created in Appendix B, Problem 6. Create a data dictionary for the verified model.
Verify the conceptual model you created in Appendix B, Problem 7. Create a data dictionary for the verified model.
Design and verify a database application for one of your local not-for-profit organizations (for example, the Red Cross, the Salvation Army, your church, mosque, or synagogue). Create a data
Using the information given in the physical design section (C.5), estimate the space requirements for the following entities:RESERVATIONINV_TRANSTR_ITEMLOGITEMINV_TYPE
Mainframe computing used to be the only way to manage data. Then personal computers changed the data management scene. How do those two computing styles differ, and how did the shift to PC-based
Describe the client and the server components of the client/server computing model. Give examples of server services.
Using the OSI network reference model, explain the communications middleware component's function.
What major network communications protocols are currently in use?
Explain what middleware is and what it does. Why would MIS managers be particularly interested in such software?
Suppose you are currently considering the purchase of a client/server DBMS. What characteristics should you look for? Why?
Describe and contrast the four client/server computing architectural styles that were introduced in this appendix.
Contrast client/server and traditional data processing.
Discuss and evaluate the following statement: There are no unusual managerial issues related to the introduction of client/server systems.
Identify the main computing style of your university computing infrastructure. Then recommend improvements based on client/server strategy.
Explain how encapsulation provides a contrast to traditional programming constructs such as record definition. What benefits are obtained through encapsulation? Give an example.
What is an object space? Using a graphic representation of objects, depict the relationship(s) that exist between a student taking several classes and a class taken by several students. What type of
Compare and contrast the OODM with the ER and relational models. How is a weak entity represented in the OODM? Give examples.
What are the essential differences between the relational database model and the object database model?
Using a simple invoicing system as your point of departure, explain how its representation in an entity relationship model (ERM) differs from its representation in an object data model (ODM).
What are the essential differences between an RDBMS and an OODBMS?
Discuss the object/relational model's characteristics.
Describe e-commerce architecture: then briefly describe each one of its components.
What types of services are provided by the bottom layer of the e-commerce architecture?
Name and explain the operation of the main building blocks of the Internet and its basic services.
What does business-enabling do? What services layer does it provide? Give six examples of business enabling services.
What is the definition of security? Explain why security is so important for e-commerce transactions.
Give an example of an e-commerce transaction scenario. What three things should security be concerned with in this e-commerce transaction?
You are hired as a resource security officer for an e-commerce company. Briefly discuss what technical issues you must address in your security plan.
Use the Internet at your university computer lab or home to research the scenarios described in Problems 1-10. Then work through the following problems:a. What web sites did you visit?b. Classify
Research – and document -- the purchase of a new car. Based on your research, explain why you plan to buy this car.
Research – and document -- the purchase of a new house.
You are in the market for a new job. Search the web for your ideal job. Document your job search and your job selection.
You need to do your taxes. Download IRS form 1040 and look for online tax processing help, documenting your search.
Research the purchase of a 20-year level term life insurance policy and report your findings.
Research – and document -- the purchase of a new computer.
Vacation time is almost here! Research—and document—the destination(s) and activities of next summer’s vacation.
You have some money to invest. Research – and document -- mutual funds information for investment purposes. Report your investment decision(s) based on the research you conduct.
What two courses of action are available to a designer when encountering a multivalued attribute?
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,

Showing 1 - 100 of 697