i)Steps during database design process
1. Determine the purpose of your database - This helps prepare you for the remaining steps.
2. Find and organize the information required - Gather all of the types of information you
might want to record in the database, such as product name and order number.
3. Divide the information into .tables - Divide your information items into major entities or
subjects, such as products or Orders. Each subject then becomes a table.
4. Turn information items into columns - Decide what information you want to store in each
table. Each item becomes a field, and is displayed as a column in the table. For example,
an Employees table might include fields such as Last Name and Hire Date.
5. Specify primary keys - Choose each table's primary key. The primary key is a column
that is used to uniquely identify each row. An example might be Product ID or Order LD.
6. Set up the table relationships - Look at each table and decide how the data in one table is
related to the data in other tables. Add fields to tables or create new tables to clarify the
relationships, as necessary.
7. Refine your design - Analyze your design for errors. Create the tables and add a few
records of sample data.
See if you caii get the results you want from your tables. Make adjustments to the design,
as needed.
8. Apply the normalization rules - Apply the data normalization rules to see if your tables
are structured correctly, make adjustments to the tables
(ii) Advantages of databases over traditional file systems
- Ease of sharing resources
- Improved data integrity
- The information is easy to access at any time,
- There is data independence
- Many people can access the same database at the same time.
- Improved data security.
- Reduced data entry, storage, and retrieval costs
Kavungya answered the question on May 14, 2019 at 07:07
- Modern accounting software packages are designed to simplify and automate complex manual
financial management processes and improve the accessibility, accuracy and timelines of
financial data
Discuss the key...(Solved)
Modern accounting software packages are designed to simplify and automate complex manual
financial management processes and improve the accessibility, accuracy and timelines of
financial data
Discuss the key features and capabilities of accounting software packages which enable
organizations to simplify and automate financial management processes
Date posted: May 14, 2019. Answers (1)
- Identify six facilities which are required by data processing applications(Solved)
Identify six facilities which are required by data processing applications
Date posted: May 14, 2019. Answers (1)
- Outline six data processing operations in an organisation(Solved)
Outline six data processing operations in an organisation
Date posted: May 14, 2019. Answers (1)
- (i) Define a presentation program.
(ii) Highlight two major components of a presentation program.(Solved)
(i) Define a presentation program.
(ii) Highlight two major components of a presentation program.
Date posted: May 14, 2019. Answers (1)
- Briefly explain five features of a spreadsheet package.(Solved)
Briefly explain five features of a spreadsheet package.
Date posted: May 14, 2019. Answers (1)
- Explain three advantages of a centralized database.(Solved)
Explain three advantages of a centralized database.
Date posted: May 14, 2019. Answers (1)
- Outline four major steps/or mail merging a document in word processing.(Solved)
Outline four major steps/or mail merging a document in word processing.
Date posted: May 14, 2019. Answers (1)
- Highlight two uses of each of the following application packages in business:
i) Presentation program,
ii) Database program,
iii) Spreadsheet program,(Solved)
Highlight two uses of each of the following application packages in business:
i) Presentation program,
ii) Database program,
iii) Spreadsheet program,
Date posted: May 14, 2019. Answers (1)
- Briefly explain the features of the following- file system
i) Disk file system
ii) Network file system
iii) Flash file system
iv) Special purpose file system(Solved)
Briefly explain the features of the following- file system
i) Disk file system
ii) Network file system
iii) Flash file system
iv) Special purpose file system
Date posted: May 13, 2019. Answers (1)
- a) Describe four aspects of file design that should be considered for a file in which
performance has high priority.
b) Outline four differences between a file...(Solved)
a) Describe four aspects of file design that should be considered for a file in which
performance has high priority.
b) Outline four differences between a file system and a database management system.
Date posted: May 13, 2019. Answers (1)
- Identify five types of file extensions.(Solved)
Identify five types of file extensions.
Date posted: May 13, 2019. Answers (1)
- Explain the following methods of organising computer file:
i. Sequential file organisation.
ii. Hash access file organisation.(Solved)
Explain the following methods of organising computer file:
i. Sequential file organisation.
ii. Hash access file organisation.
Date posted: May 13, 2019. Answers (1)
- Mr. Jackson Wabengo, the information communication manager of Vijana Enterprises Ltd.
intends to change the operating system platform in his organisation. He intends to embrace open
source...(Solved)
Mr. Jackson Wabengo, the information communication manager of Vijana Enterprises Ltd.
intends to change the operating system platform in his organisation. He intends to embrace open
source platforms in order to save the cost of annual licenses.
Required:
i) Define the term "open source platform".
ii) Briefly explain three advantages of open source platforms.
Date posted: May 13, 2019. Answers (1)
- Briefly describe the following types of operating systems:
i) Real time operating systems.
ii) Multi-user operating systems.(Solved)
Briefly describe the following types of operating systems:
i) Real time operating systems.
ii) Multi-user operating systems.
Date posted: May 13, 2019. Answers (1)
- The operating system acts as the resource manager of a computer system
Highlight four functions which are performed by an operating system in managing a computer
system's...(Solved)
The operating system acts as the resource manager of a computer system
Highlight four functions which are performed by an operating system in managing a computer
system's resources.
Date posted: May 13, 2019. Answers (1)
- The operating system primarily provides services for running applications on a computer
system Briefly discuss the need for an operating system(Solved)
The operating system primarily provides services for running applications on a computer
system Briefly discuss the need for an operating system
Date posted: May 13, 2019. Answers (1)
- a) Briefly explain six functional areas Served by a computer operating system.
b) Outline six activities undertaken during the information system implementation and
evaluation stage.
c) Highlight eight...(Solved)
a) Briefly explain six functional areas Served by a computer operating system.
b) Outline six activities undertaken during the information system implementation and
evaluation stage.
c) Highlight eight situations in a typical, office environment where connection between
computing devices might be required.
Date posted: May 13, 2019. Answers (1)
- Highlight ten tasks performed in the creative stage of systems development life cycle.(Solved)
Highlight ten tasks performed in the creative stage of systems development life cycle.
Date posted: May 13, 2019. Answers (1)
- Identify five activities of tin operating system in regard to file management.(Solved)
Identify five activities of tin operating system in regard to file management.
Date posted: May 13, 2019. Answers (1)
- (i) State three activities that take place during computer booting process.
(ii) Identify three features of a Basic Input/output system,(Solved)
(i) State three activities that take place during computer booting process.
(ii) Identify three features of a Basic Input/output system,
Date posted: May 13, 2019. Answers (1)