So, don't be sad and enjoy your day okay ? ^^
Okay, this entry i want to summarize or refreshing your mind about what we have learned. :)
This chapter is about storing organizational information databases.
What is databases ?
maintain info about various types of objects (inventory), event (transaction),
people (employees) and places (warehouses).
for example UiTM student portal and facebook
Databases models include :
① Hierarchical database model - organized into tree-like structure
② Network database model - representing objects and relationship
③ Relational database model - stores information in form of logically related two dimensional tables
② Network database model - representing objects and relationship
③ Relational database model - stores information in form of logically related two dimensional tables
Entity : person, place, thing, transaction or event about which info is stored
Attribute : field or columns, characteristics or properties of an entity class.
Primary class and foreign keys identify various entity classes in database.
Primary key - a field that uniquely identifies a given entity in a table.
Foreign key - primary key of 1 table an attribute in another table and acts to provide a logical relationship among two tables
As we know, databases advantage from a business perspective include :
1. increased flexibility
2. increased scalability and performance
3. reduce info redundancy
4. increase info integrity
4. increase information integrity
Database management systems also known as DBMS is software through which users and application programs interact with database.
Data driven Management is an interactive website kept constantly updated and relevant to the needs of its customers thru the use of database.
Information must integrate among multiple database and divide into two that is Forward Integration and Backward Integration.
Forward Integration takes information entered into given system and sends it automatically to all downstreams system and processes.
Backward Integration takes information entered into given system and sends it automatically to all upstream systems and processes.
Thats all i want to share.
Thanks for reading :D