Tags » Primary Key

Creating database objects (3)

1.3 Creating and modify constraints

One may never guess the kind of data that enters into the database. So we need to enforce some kind of validations to ensure that the right kind of data enters into the tables. 742 more words

Seimbang

Pada dasarnya, seluruh sistem di alam semesta ini akan mengarah pada keseimbangan. QS. Ar-Rahman:7-9 Alloh SWT. berfirman:

[7] Dan Allah telah meninggikan langit dan Dia ciptakan keseimbangan.

510 more words
Primary Key

software engineering course – lecture 11 (database design)

Today I have also recorded my 11th lecture in software engineering course. It is about software engineering, database design, entity relationship diagram, ER diagram, normalization, master data, transaction data, primary key, foreign key etc.. 7 more words

Software Engineering

SQL GROUP BY and Functional Dependencies: A Very Useful Feature

Relational databases define the term “Functional Dependency” as such (from Wikipedia):

In relational database theory, a functional dependency is a constraint between two sets of attributes in a relation from a database.

458 more words
Sql

Hap..Hap.. Hap

Suka banget sama hadits ini:

Barang siapa menempuh suatu jalan untuk menuntut ilmu maka Allah memudahkan jalannya menuju Surga. Sesungguhnya para Malaikat membentangkan sayapnya untuk orang yang menuntut ilmu karena ridha atas apa yang mereka lakukan.

317 more words
Primary Key

Let's Go Higher

Dalam hadits arba’in ke-21,

Dari Abu Amr, -ada juga yang mengatakan- Abu ‘Amrah, Suufyan bin Abdillah Ats Tsaqofi radhiallahuanhu dia berkata, saya berkata : Wahai Rasulullah shollallohu ‘alaihi wa sallam, katakan kepada saya tentang Islam sebuah perkataan yang tidak saya tanyakan kepada seorangpun selainmu.

300 more words
Primary Key

PK DROP CREATE PARALLEL

alter session set sort_area_size=2147483647;

alter table t1 drop constraint pk_t1;

alter table t1
add constraint pk_t1
primary key (col1, col2, ..)
disable;

drop index pk_t1;

create unique index pk_t1
on t1 (col1, col2, ..)
parallel 16;

alter index pk_t1 noparallel;

alter table t1 enable primary key;
ORACLE