WEEK 4

• DATABASE – is an organized collection of data, It is also a collection of non-redundant data.
• DBMS –is a software that interacts with the user, other applications and the database itself.
• Conceptual Data Model - specifies the structure of the data and the processes which use that data.
• Data Analysis - establishing the nature of data.
• Functional Analysis - establishing the use of data.
• Database Study - here the designer creates a written specification in words for the database system to be built.
• Database design - conceptual, logical, and physical design steps in taking specifications to physical implementable designs.
• Operation - this step is where the database is actually in real usage by the company.
• National language processing NLP - is a branch of artificial intelligence
• Database design - is the process of producing a detailed data model
• Entities - information that are saved in the database
• Recursive relationships - are often used to represent hierarchies or networks
• redundant relationship - exists when two or more relationships represent the same concept
• Normalization 1st form – no repeating groups of columns
• Normalization 2nd form– fully dependent on the primary key
• Normalization 3rd form - directly dependent on the primary key.