Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

15 Questions – [Each question carry 1 mark] 1.Which is NOT a step in moving from

ID: 3688960 • Letter: 1

Question

15 Questions – [Each question carry 1 mark]

1.Which is NOT a step in moving from a logical data model to a physical data model?

A.Change entities to tables

B.Change data flows to create, read, update, delete operations

C.Change Attributes to Fields

D.Add primary keys

E.Add foreign keys

2.Designing interfaces that are pleasing to the eye is known as:

A.Layout

B.Content awareness

C.Aesthetics

D.Consistency

E.Minimal user effort

3.In which of the SDLC phases the data storage design activity is done.

A.Planning

B.Analysis

C.Design

D.Implementation

E.Evaluation

4.A higher-level component that contains the logic for performing other modules and the components that it calls and controls is called:

A.structure chart

B.control module

C.subordinate module

D.super-ordinate

E.top-down module chart

5.One of the following is not a common Interface Evaluation technique

A.Interactive evaluation

B.Walk-through evaluation

C.Heuristic evaluation

D.Use scenario normalization

E.Formal usability testing

6.The best way to optimize data storage for efficiency is:

A.Normalization

B.Redundancy

C.Null values

D.Insertion of hard returns after all fields

E.Indexing

7.The process that defines the basic components of the interface and how they work together to provide functionality to users is known as:

A.Use Scenario Design

B.Interface Standards Design

C.Interface Metaphor

D.Interface Structure Design

E.Interface Template Design

8.It is necessary when changing a logical DFD into a physical DFD to:

A.Normalize the logical DFD into 3NF

B.Create the user-interface with smaller fonts

C.Add system-related data stores, data flows and processes

D.Change the system architecture to three-tiered architecture

E.Delete extraneous data stores and delete extraneous data flows

9.For the most efficient storage, the database designer should remove:

A.Redundancy and null values

B.Primary keys and foreign keys

C.International keys and redundancy

D.Adjectives and adverbs

E.Special characters and primary keys

10.The CRUD matrix shows:

A.Exactly how data are used and created by the major processes in the system

B.The 1:M relationships on an ERD diagram

C.Where customer, relationships, users and developers will interact with a system

D.The external entities, process and major data flows from the Context DFD diagram

E.The crud that is coming into the system and how to quarantine it

11.In the user interface design, the principle of using the fewest keystrokes is known as:

A.Layout

B.Consistency

C.Minimal User Effort

D.Content Awareness

E.User Experience

12..The first step in creating a Physical Data Flow Diagram is:

A.Update the metadata in the CASE repository

B.Add implementation references

C.Draw a human-machine boundary

D.Add system-related data stores, data flows and processes

E.Update the data elements in the data flows

13.In the user interface design process, when the analysts examine the DFDs and use cases developed in the analysis phase and interview users, the analyst will develop:

A.Interface structure diagram

B.Case scenario

C.Interface design prototype

D.Interface standards

E.Physical DFD

14.The series of areas on the screen that are used consistently for different purposes are called:

A.Layouts

B.Forms

C.Reports

D.Buttons

E.Menus

15.In a structure chart, the element that communicates that a message or a system flag is being passed from one module to another is known as:

A.conditional line

B.connector

C.data couple

D.loop

E.control couple

Part-II – Short Answer Questions

[4 Questions – Each question carry 4 mark]

1.What are the differences between the logical and physical ERDs?                         [4 points]

2.At the end of the design phase, there is a document named the system specification that describes the different design documents and their uses. What is the consolidated purpose of this deliverable and why is it important?                                                                  [4 points]

3.What is referential integrity and how is it implemented in a relational database?      [4 points]

4.Compare between the types of interface design prototypes.                                      [4 points]

Part IV – Long Answer Questions

[4 Questions – 19 points]

A university has an online registration system that enables the staff of each academic department to examine the courses offered by their department, add and remove courses, and change the information about them (e.g., the maximum number of students permitted). It should permit students to examine currently available courses, add and drop courses to and from their schedules, and examine the courses for which they are enrolled. Department staff should be able to print a variety of reports about the courses and the students enrolled in them. The system should ensure that no student takes too many courses and that students who have any unpaid fees are not permitted to register. (Assume that a fees data store is maintained by the university’s financial office, which the registration system accesses but does not change).                                                                                                                       

1.Draw a level-0 data flow diagram (DFD) for the university registration system.      [5 points]

2.Draw an Interface Structure Diagram (ISD) for the university registration system. [5 points]

3.Based on the data flow diagram created in section 1, create a structure chart for the system.

[5 points]

4.Develop a use scenario for the university registration system.                                   [4 points]

Explanation / Answer

1.
B.Change data flows to create, read, update, delete operations

2.
A.Layout

3.
C.Design

4.
B.control module

5.
D.Use scenario normalization

6.
A.Normalization

7.
D.Interface Structure Design

8.
E.Delete extraneous data stores and delete extraneous data flows

9.
A.Redundancy and null values

10.
C.Where customer, relationships, users and developers will interact with a system

11.
C.Minimal User Effort

12.
D.Add system-related data stores, data flows and processes

13.
B.Case scenario

14.
E.Menus

15.
B.connector

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote