Database Design and Management: An Interdisciplinary Approach

This class deals primarily with business-oriented database design, especially with reference to organizational system and business-oriented applications (BIS) regarding information technology (IET) and database design for business. Information technology (IT) is the application of computer science and engineering to provide solutions for business requirements through the utilization of database systems. This class combines fundamental database design theory with the practical application to explain and execute database system design solutions.

The main aim of the Database Design and Administration elective is to give students an overview of the concept of database design, development and administration. It covers the fundamentals of database design with emphasis on designing and managing database driven software systems. The database designer plays a key role in implementing solutions for database driven software systems. This person is also called a database administrator or a database manager.

The object model is the basic modeling tool used in database design and its development. This tool controls how users can interact with the database and the entities. The data model shows how the entity is represented by the users and the objects are implemented as subtypes of the entities. Owing to its nature, an entity database usually has an optimized data model that minimizes changes at database creation time and that ensures consistency at all times. The data models in database design and administration courses are used to minimize changes at database design and database maintenance time.

The purpose of the security and concurrency systems analysis electives is to give students an in-depth study of security, concurrency, and disaster recovery modeling. This area of database design and administration deals specifically with these aspects. Security systems analysis is usually done in the context of a network or a system. Concurrent concurrency management is concerned with the ability of the application to handle work requests from multiple workers simultaneously without any failure. Disaster recovery modeling deals with the preparation of plans to recover if the entire system or network fails.

Database design and administration courses usually set out several conceptual data models and associated design steps involved with each model. Some of these steps include creating a database design, loading of the database, designing the user database, validating user data, and finally organizing the database. These conceptual data models are used to identify the various database design and administration tasks required to develop any database. Many such courses include some laboratory activities to test the application of each model. The laboratory activities bring into focus how one would use a particular model to meet user requirements.

The information systems department at ITIL helps to train students on the database technologies used to develop enterprise-wide information systems. It offers information systems training in ITIL certification for professionals already working in the industry or students interested in becoming part of this expanding field. The courses help students analyze current business scenarios to design and develop comprehensive business information systems. It also trains students how to evaluate the business case for implementing a new system.

Database design and development process are usually divided into three phases, and each phase has a specific name. The planning, development and implementation of a database development process comprises two major stages. The first stage involves a thorough discussion of requirements, which is done primarily by those involved in database design and development. Based on the needs analysis, the second stage commences where a detailed plan for the database design and implementation process is laid out.

The third stage includes the critical stage, in which the technical and economic issues are addressed using a formal data model developed by the team. The final stage, known as evaluation stage, consists of the verification of the formal data model, which verifies the information presented. Database design and database development process thus have a close relationship that goes beyond the IT industry.