WEB-BASED DATABASE DESIGN & DATA DESIGN TERMINOLOGY

WEB-BASED DATABASE DESIGN

Web-based systems are popular because they offer ease of access, cost-effectiveness, and worldwide connectivity.

Gambar 1: Web-based design characteristics.

Web-based data must be secure, yet easily accessible to authorized users. To achieve this goal, well-designed systems provide security at three levels: the database itself, the Web server, and the telecommunication links that connect the components of the system.

DATA DESIGN TERMINOLOGY 

1. ENTITY is a person, place, thing, or event for which data is collected and maintained.
2. TABLE OR FILE contains a set of related records that store data about a specific entity.
3. FIELD also called an attribute, is a single characteristic or fact about an entity.
4. RECORD is a set of related fields that describes one instance, or occurrence of an entity, such as one customer, one order, or one product.
5. Key Fields, you use key fields to organize, access, and maintain data structures. The four types of keys are primary keys, candidate keys, foreign keys, and secondary keys.

1. PRIMARY KEYis a field or combination of fields that uniquely and minimally identifies a particular member of an entity.
2. CANDIDATE KEY Sometimes you have a choice of fields or field combinations to use as the primary key.
3. FOREIGN KEY Recall that a common field exists in more than one table and can be used to form a relationship, or link, between the tables.
4. SECONDARY KEY A secondary key is a field or combination of fields that can be used to access or retrieve records. Secondary key values are not unique.

Gambar 2: Contoh dalam menunjukan terminology data desain.

Penulis: Yusia /Kaleb

Referensi:
[1] Shelly, G.B., Rosenblatt, H.J., Systems Analysis and Design Ninth Edition. Course Technology. 2012. Boston, USA.