Perancangan Basis Database Design Planning Database Design Planning

Perancangan Basis Database Design Planning

Database Design Planning • • What Is a Database Design? Importance of Database Design Planning Database Design Trademarks of a Solid Database Design Overview of Design Methodologies Logical Versus Physical Modeling Automated Design Tools 9/7/2021 2

What Is a Database Design? Menurut Webster’s Dictionary : • “To prepare the preliminary plans or sketch for” • “To intend for a definite purpose” • “The combination of details or features of something constructed” • “To plan and fashion artistically or skillfully” • “Adaptation of means to a preconceived end” 9/7/2021 3

What Is a Database Design? 3 tahapan dasar dalam “database design” : • “Requirements gathering” • “Data modeling” • “Database design and normalization” 9/7/2021 4

Planning Database Design • • • Defining the mission statement & mission objectives Devising a work plan Setting milestones and deliverables Establishing project team Assigning tasks 9/7/2021 5

Planning Database Design Defining the mission statement & mission objectives • Mission Statement adalah ringkasan dari tujuan keseluruhan dari database yang diusulkan. • Yang terlibat : Management, developers, and end users. • Mission Objectives akan digunakan untuk menyusun rencana desain dan membangun milestones yang menandai progress pengembangan proyek. 9/7/2021 6

Planning Database Design Defining the mission statement & mission objectives (Question) • What is the purpose of the database? • Who will use the database? • What type of database will this be? • Is this a new database? • Will the database need to be modified in the near future? 9/7/2021 7

Planning Database Design Defining the mission statement & mission objectives (Case Study) Kita akan merancang suatu database menggunakan model relasional. Proses bisnisnya adalah pendaftaran siswa untuk sebuah lembaga pelatihan kecil. Mari kita sebut pelatihan ini Traintech. Informasi dasar yang harus dipertahankan dalam database ini meliputi : • • Class information Instructor information Student/customer information Class schedules Class materials Accounts payable Accounts receivable 9/7/2021 8

Planning Database Design Mission Statement & Mission Objectives (Case Study) • Mission Statement : Sebuah sistem bisnis otomatis yang diperlukan untuk mengelola dan melacak pendaftaran siswa, jadwal, instruktur, dan ketersediaan instruktur. • Mission Objectives : 1. 2. 3. 4. 5. Setiap proses yang manual akan menjadi otomatis. Pengguna internal akan mengakses database. Model relasional akan digunakan. Saat ini tidak ada database di Traintech. Database mungkin perlu dimodifikasi sebagai lembaga pelatihan yang sedang berkembang. 6. Di masa depan, sebagian dari database dapat dibuat tersedia secara online sehingga siswa dapat query status kelas atau program yang mereka dijadwalkan 9/7/2021 9

Planning Database Design • Devising a work plan Sebuah work plan merupakan outline yang memecah langkah-langkah perancangan yang ada. Berikut ini adalah pertimbangan awal untuk merancang work plan : • • • Location of the work to be conducted. A design team must be established. Business rules. Hardware to be used. Software to be used. Tools for development. Tools for the end users. Backup plan for development work done. Database environments used for development. 9/7/2021 10

Planning Database Design • Setting milestones and deliverables Sebuah milestone adalah poin penting dalam proses desain database. Berikut ini adalah milestones yang umumnya ditetapkan: • All business requirements are gathered. • A work plan is devised. • Entities and attributes are established. • The logical design of the database is complete. • The physical design of the database is complete. • The database is tested. • The database is implemented into production. 9/7/2021 11

Planning Database Design • Establishing the Design Team 9/7/2021 12

Planning Database Design • Assigning Tasks 9/7/2021 13

Trademarks of a Solid Database Design Trademarks of a good database design include : • • • A functional database is generated. The database accurately represents the business’s data. The database will be easy to use and maintain. Acceptable response time exists for the end users. Modifications are easily made to the structure. Data can be retrieved and modified easily. Down time because of poor design is minimized. Very little maintenance is needed. Data is kept safe by planning for security. Redundant data is minimized or nonexistent. Data can be easily backed up or recovered. The actual structure of the database will be virtually transparent to the end user. 9/7/2021 14

Overview of Design Methodologies • Design methodology traditionally involves the following three phases: 1. Requirements analysis 2. Data modeling 3. Design and Normalization 9/7/2021 15

Logical Versus Physical Modeling • Logical Modelling Typical design phases that apply to logical modeling: • Gathering requirements • Requirements analysis Typical deliverables of logical modeling include : • Entity relationship diagrams • Business process diagrams • User feedback documentation 9/7/2021 16

Logical Versus Physical Modeling • Physical Modelling Typical design phases that apply to physical modeling: • Design • Implementation • Maintenance Typical deliverables of physical modeling include : • Server model diagrams • User feedback documentation • Database design documentation 9/7/2021 17

Any Question ? 9/7/2021 18