System Analysis and Design · Unit 4 · 7 hrs
Design
Exam-focused notes for Design (System Analysis and Design, CSC326): what the TU syllabus asks and how it has actually been tested, with 9 solved past questions from this unit.
What this unit covers
- Designing Databases: Introduction
- Database Design
- Relational Database Model
- Normalization
- Transforming E-R Diagrams Into Relations
- Merging Relations
- Physical File and Database Design
- Designing Fields
- Designing Physical Tables
- Designing Forms and Reports: Introduction
- Designing Forms and Reports
- Formatting Forms and Reports
- Assessing Usability
- Designing Interfaces and Dialogues: Introduction
- Designing Interfaces and Dialogues
- Interaction Methods and Devices
- Designing Interfaces
- Designing Dialogues
- Designing Interfaces and Dialogues in Graphical Environments
Designing Dialogues
Explain the steps involved in the dialogue design process. [5]
Dialogue design focuses on the sequencing of interface displays and defines the manner in which humans and computers exchange information. The process of designing the overall sequences that users follow to interact with an information system is called dial...
Full solved answer →Designing Physical Tables
Describe the process of designing physical tables. [5]
A physical table is a named set of rows and columns that specifies fields in each row of the table. It is the concrete implementation of logical data structures in secondary storage. --- The design of a physical table has two primary goals: 1. Efficient use...
Full solved answer →Designing Interfaces
How do you think effective interfaces can be designed? Explain. [5]
A user interface (UI) is the front-end application view through which a user interacts with software. Effective interface design makes software more popular, usable, and efficient. The software becomes more popular if its user interface is attractive, simpl...
Full solved answer →Normalization
List the advantages of Normalization. Explain 2NF with an example. [5]
--- Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. Its key advantages are: 1. Eliminates Data Redundancy: Removes duplicate data stored across multiple tables, saving storage space. 2. Prevents...
Full solved answer →Physical File and Database Design
Explain physical database design. Why is physical database design important? Differentiate logical database design with physical database design.[10]
Physical database design is the process of transforming a logical database model into a physical implementation on a specific hardware and software platform. It involves decisions about how data will be physically stored, accessed, and managed in secondary ...
Full solved answer →Interaction Methods and Devices
Describe several methods for interacting with the system. [5]
User interaction methods define how a user communicates with a software system to invoke operations and receive responses. The following are the main methods of interacting with a system: --- - This method requires users to remember command syntax and seman...
Full solved answer →Designing Forms and Reports
Compare form with report. Explain the process of designing forms and reports. [5]
--- Basis Form Report --------- Purpose Used to collect or present information on a single item (e.g., customer, product, event) Product of input and output design; used to present summarized or detailed information Usage Can be used for both input and outp...
Full solved answer →Database Design
What is the purpose of database design? Compare logical design with physical design. [5]
Database design is the organization of data according to a database model. The main purpose of database design is to: - Produce logical and physical designs of the proposed database system - Meet the requirements of users - Ensure high performance of the da...
Full solved answer →Formatting Forms and Reports
How do you format forms and reports? Explain general guidelines for formatting forms and reports. [5]
Forms are used to collect or present information on a single item (such as a customer, product, or event) and can be used for both input and output. Reports are purely used for reading and are the product of input and output design. Proper formatting of bot...
Full solved answer →Make Unit 4 stick
Practice CSC326 with flashcards & quizzes