GILAKAMEN RDMS!!!!!!

weekly reflection 1

*today is the first class, lecturer divide group for us. she us each group to presant our name, moto and rules in a group.

*after that, we learn chapter 1. we learn about client and server. we also learn overview of DBMS. it's not much differences that what we learn in DADD except a four new things.

*in chapter 2, we learn about EER. there's superclass and subclass where we must determine which will become superclass or subclass.

*total specialization where every entity of superclass must belong to at least one subclass.

*partial specialization where at least one entity of subclass is not belong to any subclass.

*disjoint constraint is about a superclass can belong to most of subclass.

*overlapping constraint specifier that every number of superclass can belong to more than one of the subclass.

*generalization where an entity is made to combine and make a superclass.

*categorization where a single subclass with a relationship that involves more than one distinct superclass.

weekly reflection 4

* we learn how to put primary key and foreign key in the table.

*primary key: create table table_name(field_name1 datatype(field_size)primary key,
field_name2 datatype(field_size))engine=innodb;

*foreign key: create table table_name(field_name1 datatype(field_size)primary key,

field_name2 datatype(field_size),

foreign key(foreing_key_in_table) references table_name_to_be_refer(primary_key_to_be_references))engine=innodb;

WEEKLY REFLECTION 2

Today we continue our of RDMS of chapter 2 . it is about steps in working EER and there are 8 steps

Identify entity types
Identify relationship types
Determine cardinality constraints
identify and associate attributes
Determine candidate and primary key
Specialize/generalize entity types
Categorize entity types
Draw the EER diagram

We also learn about relational data model, it is the same as in DADD but only in design, we also learn about characteristics of relation which has 6 characteristic and about key functional dependencies and the formula is A --> B

Today also move to chapter3 about Database Development Process. on components of information system we learn about components of information systems which has 5 components.

People
procedure
Software
Hardware
Data

There are 5 Process in SDLC

Preliminary study
System analysis
System design
System Implementation
Maintainance

There are 2 methodologies in SDLC

Spiral Development Methodologies (Spiral)
Rapid application Development Methodologies (RAD)

DBLC is ssimilar to SDLC

Database initial study
Database design
Implementation and loading
Testing and evaluation
Operation
maintainance and evolution

Important in Database Development is skill. there are 2 skill needed which is

soft skill
hard skill

There are 2 tools of Database Development

font_end (upper_CASE)
back_end (lower_CASE)

weekly reflection 5

* we do some revision for midterm exam.

* a lot of sample past year question are given.

* the examples of question is :
- what is a DBMS?
-what do you mean by procedural access?
-what is the difference between a file based database and DBMS?
-list down some advantages of a DBMS.

WEEKLY REFLECTION 3

Start class on 11am
Download xampp
Rest
Miss explain how to do the database

how to create database
how to insert the data
insert the field name,data type
change column and field name

   5. Create table

   create table_table_table_name (field_name1 data_type (field_size),
   (field_name2 data_type (field_size),

   6. How to show all the table in the database you're created :

   show tables ;

   How to show your table that you're ceated

   describe table_name ;

   7. How to insert the record/data in table