Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
What is the advantage of using different types of cursors? Explain forward-only cursors. Give an example of their use.
Explain static cursors. Explain keyset cursors. Explain dynamic cursors. Give an example of their use.
Explain the necessity of defining processing rights and responsibilities. How are such responsibilities enforced?
Define the terms rollback and rollforward. Why is it important to write to a log before changing the database values?
What is the advantage of making frequent checkpoints of a database? Summarize a DBA's responsibilities for managing database user problems.
What types of cursors, if any, does Microsoft SQL Server 2012 use? How does the security model for Microsoft SQL Server 2012 differ from that shown?
Assume that many Service Update Transactions and many Service Update. Describe a scenario for a nonrepeatable read and a scenario for a phantom read.
Write SQL CREATE TABLE statements for each of these tables. Write SQL statements to insert at least three rows of data into each of these tables.
Create SQL statements to list all columns for all tables. Write an SQL statement to list ItemID and ItemDescription for all items that cost $1000 or more.
Write an SQL statement to list LastName, FirstName, and Phone of the customer who made the purchase with SaleID 1. Use a subquery.
Write an SQL statement to modify the vendor with CompanyName of Linens and Things to Linens and Other Stuff.
What is a data model, and what is its purpose? What is a prototype, and what is its purpose? What is a use case, and what is its purpose?
Give an example of a data constraint. Give an example of a business rule that would need to be documented in a database development project.
Define the term degree of relationship. Give an example, other than one used in this text, of a relationship greater than degree two.
Define the terms maximum cardinality and minimum cardinality. Draw both a traditional E-R diagram and an IE Crow's Foot E-R diagram for each.
Define the term ID-dependent entity and give an example other than one used in this text. Draw an IE Crow's Foot E-R diagram for your example.
Define the terms supertype, subtype, and discriminator. What is an exclusive subtype relationship? Give an example other than one shown in this book.
Draw an E-R data model based on the traffic citation form. Use five entities, and use the date items on form to specify identifiers and attributes for entities.
Prepare appropriate identifiers and attributes for each entity. Justify the decisions you make regarding minimum and maximum cardinality.
Create appropriate identifiers and attributes for each entity. Justify the decisions you make regarding minimum and maximum cardinality.
Define the term foreign key and give an example. Explain how supertype and subtype entities are transformed into tables.
Define the terms parent and child as they apply to tables in a database design and give an example of each.
Why is it important to integrate the SDLC process? You should have a title slide, a table of contents slide, and a reference list slide.
Find articles that explains the different types of operating systems (Linux, Unix, Android, ROS, z/OS, z/VM, z/VSE, etc). Do not select MS WINDOWS.
Create a multiprotocol operational network using EIGRP, OSPF, and RIPv2 protocol. Implement a secure update of OSPF and EIGRP protocol.