Write 2 pages with APA style on Presentation Outline. Presentation outline Presentation outline INTRODUCTION I. Goals of the database design II. Definition of terms III. Significanceof a database desi

Write 2 pages with APA style on Presentation Outline. Presentation outline Presentation outline INTRODUCTION I. Goals of the database design II. Definition of terms III. Significanceof a database design

Eliminates redundant data

Consistency

Enhances application performance

Enables easier maintenance

IV. Thesis statement: Database design has become a fundamental part in the development of efficient applications and programs all over the world.

BODY

I. Overview of the database design

1. Detailed explanation about the benefits of the design

2. Explanation of the challenges faced during the design of the database

Table ratio

Data stability

Data and query complexity

II. Chapter one: Who Needs a Database?

1. Overview of individuals who need database management systems

2. The relational model

3. The history of the relational model as proposed by Edgar F. in the late 1960s

4. An brief introduction of the Microsoft SQL Express program

5. The role of SQL in relational databases

6. Statement of the scope for the database

III. Chapter two: Gathering Information

1. Prepare relevant documents required in the database design

2. Gather all the data required for developing the tables and reports

The data can be obtained by checking the relevant documents, performing interviews or preparing a questionnaire.

3. Documentation

The documentation process helps in keeping data records during the design process. It contains a summary of the vital data contained in the application. The entity-relation diagrams are also included in the documentation.

IV. Chapter three: Requirements and Business Rules

1. Overview of the database requirements

Data requirements

Report requirements

Security requirements

2. The UML Diagram

Overview of the UML diagrams (Use Case Diagrams)

Develop the UML diagrams

3. Review the requirements and business rules

4. Determine the amount of data to be stored in the database

V. Chapter four: Database Design

1. The Design Process

Determine the main purpose of designing the database management system

Gather and organize the data that is to be recorded

Appropriately divide related pieces of data in separate tables and define the data type for the data entered in the table

Select a suitable primary key for each table and also set up the relationships among the tables

Add redundant tables and relationships

Develop entities and add attributes

Create the appropriate relationship between the entities

Develop the entity-relationship diagram and resolve the relationships using linking tables in the design template of the software

Resolve issues with the cardinality of table relationships

2. Error Checking

Perform an error check and make the necessary adjustments in the design

VI. Chapter five: Normalization and Design Review

1. Adjust the entity-relationship diagram against the three normal forms by inserting, updating and deleting anomalies

2. Making adjustments to the tables

CONCLUSION

Designing a database is a procedure aimed at creating a comprehensive data model. In this relational model, tables are used to store and generate the information needed. The process of database design encompasses knowing the target market, gathering the required information from appropriate sources, defining the requirements of the database, the design itself and reviewing among others. This is because database design has become an essential part in the development of effective applications globally.

References

Beaulieu, A. (2009). Learning SQL. Sebastopol, CA: O’Reilly Media.

Conger, Steve. (2010). Hands on Database: An Introduction to Database Design and Development. Retrieved from http://mousegraphixdesign.com/school_projects/databases/HANDS%20ON%20DATABASE.pdf

Coronel, C., Morris, S. & Rob, P. (2012). Database Systems: Design, Implementation, and Management. Stamford, CT: Cengage Learning.

Date, C.J. (2012). Database Design and Relational Theory. Sebastopol, CA: O’Reilly Media.