Questions and Answers of Programming Logic & Design Comprehensive

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
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
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
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.
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
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
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.
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,
Capitol College maintains data about various campus organizations. The college administration has constructed a table with the structure tblOrganization(orgId, organization, membership, president,
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.
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
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
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
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
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,
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,
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
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