Managing Knowledge and Data

·         For every transaction new data is generated.

·         Data can be written in form of alphabets, numbers, pictures, videos… etc.

·         One byte = One character.

·         People might face difficulties to manage large data so they need to store them in more and more capacity.

·         Data governance --> team or group which controls all the data in big companies. For example, make regulations of data in the company or decide how many decimal places in Omani rials.

·         We can modify, edit, delete, and print the data by using DBMS.

·         Data security means protecting your data so nobody can see them.

·         The diagram that shows how tables are linked together is called as ER diagram.

·         We have three kinds of relationships when doing tables:

1-      One to one relationship --> e.g: one student can get one parking permission.

2-      One to many relationship --> e.g: one teacher can hold many sections.

3-      Many to many relationship --> e.g: many students can register in many sections.

·         The process of searching and asking questions after our tables are ready is known as queries.

·         Data warehouse is a place where new and historical data are stored; it is used in large organizations.

·         Date mart is a part of data warehouse.

·         The technique that is used for searching the hidden information id referred to data mining.

·         There are two types of knowledge:

1-      Explicit --> which can show and demonstrate + obvious + we can see.

2-      Tacit --> hidden knowledge + we can’t explain.