Programming Logic & Design Comprehensive 8th Edition Joyce Farrell - Solutions

In the UML, object diagrams are most similar to _________ diagrams.a. Use caseb. Activityc. Classd. Sequence
Develop a state machine diagram that shows the states of an Employee from Applicant to Retiree.
Develop a state machine diagram that shows the states of a Movie from Concept to Production.
In any given situation, you should choose the type of UML diagram that is _________.a. Shorter than othersb. Clearer than othersc. More detailed than othersd. Closest to the programming language you will use to implement the system
Develop an activity diagram that illustrates how to throw a party.
A whole-part relationship can be described as a(n) ______ relationship.a. Parent-childb. Has-ac. Is-ad. Creates
Develop an activity diagram that illustrates how to clean a room.
The timing of events is best portrayed in a(n) _______ diagram.a. Sequenceb. Use casec. Communicationd. Association
Develop the UML diagram of your choice that illustrates some aspect of your life.
A communication diagram is closest to a(n) _______ diagram.a. Activityb. Use casec. Deploymentd. Sequence
A(n) _________ diagram shows the different statuses of a class or object at different points in time.a. Activityb. State machinec. Sequenced. Deployment
The UML diagram that most closely resembles a conventional flowchart is a(n) ________ diagram.a. Activityb. State machinec. Sequenced. Deployment
You use a ________ diagram when you want to emphasize the files, database tables, documents, and other components used by a system’s software.a. State machineb. Componentc. Deploymentd. Use case
The UML diagram that focuses on a system’s hardware is a(n) _________ diagram.a. Deploymentb. Sequencec. Activityd. Use case
When using the UML to describe a single system, most designers would use __________ .a. A single type of diagramb. At least three types of diagramsc. Most of the available types of diagramsd. All the types of diagrams
Consider the following table with the structure tblRecipes(recipeName, timeToPrepare, ingredients). If necessary, redesign the table so it satisfies 1NF, 2NF, and 3NF. recipeName Baked lasagna Fruit salad Marinara sauce time ToPrepare 1 hour 10 minutes 30 minutes ingredients 1 pound lasagna
A field or column that uniquely identifies a row in a database table is _________ a(n) .a. Variableb. Identifierc. Principald. Key
Consider the following table with the structure tblFriends(lastName, firstName, address, birthday, phoneNumbers, emailAddresses). If necessary, redesign the table so it satisfies 1NF, 2NF, and 3NF. lastName firstName address birthday phoneNumbers Gordon Alicia 34 Second St. 3/16 Washington
Before you can enter data into a database table, you must do all of the following except __________ .a. Determine the attributes the table will holdb. Provide names for each attributec. Provide data types for each attributed. Determine maximum and minimum values for each attribute
Which of the following is the best key for a table containing a landlord’s rental properties?a. StreetAddressb. AmountOfMonthlyRentc. NumberOfBedroomsd. TenantLastName
You have created the following table to keep track of your DVD collection. The structure is tblDVDs(movie, year, actors). If necessary, redesign the table so it satisfies 1NF, 2NF, and 3NF. movie The Departed X Hairspray Catch Me If You Can True Grit Stand Up
A table’s notation is: tblClients(socialSecNum, lastName, firstName, clientNumber, balance Due). You know that _____________ .a. The primary key is socialSecNumb. The primary key is clientNumberc. There are four candidate keysd. There is at least one numeric attribute
The Midtown Ladies Auxiliary is sponsoring a scholarship for local high school students. They have constructed a table with the structure tblScholarshipApplicants(appId, lastName, hsAttended, hsAddress, gpa, honors, clubsActivities). The hsAttended and hsAddress attributes represent the high school
Capitol College maintains data about various campus organizations. The college administration has constructed a table with the structure tblOrganization(orgId, organization, membership, president, presidentMajor, vicePresident, vicePresidentMajor). A student might hold offices in more than one
You can extract subsets of data from database tables using a(n) _________ .a. Queryb. Sortc. Investigationd. Subroutine
A database table has the structure tblPhoneOrders(orderNum, custName, custPhoneNum, item Ordered, quantity). Which SQL statement could be used to extract all attributes for orders for item AB3333?a. SELECT * FROM tblPhoneOrders WHERE itemOrdered = "AB3333"b. SELECT tblPhoneOrders WHERE itemOrdered
Assume that you want to create a database to store information about your music collection. You want to be able to query the database for each of the following attributes:A particular title (for example, Tapestry or Beethoven’s Fifth Symphony)Artist (for example, Carole King or the Chicago
Connecting two database tables based on the value of a column (producing a virtual view of a new table) is a ____________ operation.a. Mergeb. Concatenatec. Joind. Met
Design a collection of database tables for the Springfield Town Council. The council is made up of representatives from each of the town’s 15 precincts. The data you need to store includes the following attributes:Precinct numberPrecinct populationCouncil representative’s last nameCouncil
Heartland Medical Clinic maintains a database to keep track of patients. One table can be described as: tblPatients(patientId, name, address, primaryPhysicianCode). Another table contains physician codes along with other physician data; it is described as tblPhysicians(physicianCode, name,
Design a collection of database tables for an online store from which you intend to sell products you handcraft. The data you need to store includes the following attributes:Product numberProduct descriptionProduct priceProduct categoryTax, which varies by priceShipping mode (for example, UPS or
Edgerton Insurance Agency sells life, home, health, and auto insurance policies. The agency maintains a database containing a table that holds policy data—each record contains the policy number, the customer’s name and address, and the type of policy purchased. For example, customer Michael
Kratz Computer Repair maintains a database that contains a table of information about each repair job the company agrees to perform. The jobs table is described as: tblJobs(jobId, dateStarted, customerId, technicianId, feeCharged). Each job has a unique ID number that serves as a key to this table.
When a column that is not a key in a table contains an attribute that is a key in a related table, the column is called a ____________ .a. Foreign keyb. Merge columnc. Internal keyd. Primary column
The most common reason to construct a one-to-one relationship between two tables is ________ .a. To save moneyb. To save timec. For security purposesd. So that neither table is considered “inferior“
The process of designing and creating a set of database tables that satisfies the users’ needs and avoids potential problems is _____ .a. Purificationb. Normalizationc. Standardizationd. Structuring
The unnecessary repetition of data is called data __________ .a. Amplificationb. Echoingc. Redundancyd. Mining
Problems with database design are caused by irregularities known as __________ .a. Glitchesb. Anomaliesc. Bugsd. Abnormalities
When you place a table into first normal form, you have eliminated ________ .a. Transitive dependenciesb. Partial key dependenciesc. Repeating groupsd. All of the above
When you place a table into third normal form, you have eliminated __________ .a. Transitive dependenciesb. Partial key dependenciesc. Repeating groupsd. All of the above
If a table contains no repeating groups, but a column depends on part of the table’s key, the table is _____ in normal form.a. Firstb. Secondc. Thirdd. Fourth
Which of the following is not a database security issue?a. Providing data integrityb. Recovering lost datac. Providing normalizationd. Providing encryption

Showing 100 - 200 of 142

1
2

Step by Step Answers