Databases: building solutions: databases

• database definition
• database management system (DBMS)
• access, oracle etc.
• Database application system (DBAS)
• student enrollment management system, enrollment management system
• data and information
• data
• unprocessed
• information
• processed
• data processing
• data integrity
• database is a valid as the correctness of the information stored and processed
• GIGO ( Garbage in Garbage Out
• data processing
• data integrity
• database is as valid as the correctness of the information stored and processed
• GIGO ( garbage in Garbage Out)
• good information characteristics
• accurate
• verifiable
• timely
• organized
• accessible
• useful and informative
• cost-effective
• data hierarchy
• data server
• database application 1
• table 1.1
• table 1,2
• record 1
• record 2
• field 1 (primary)
• field 2  
• data application 2
• table 2.1
• data types
• text
• numeric
• auto number
• currency
• date
• memo
• yes/no
• hyperlink
• object
• attachment
• maintaining data
• add
• modify
• delete
• validate
• data validation
• alphabetic/numeric check
• range check
• consistency check
• completeness check
• check digit
• Evolution of database management systems
• file processing system
• hierarchical database systems
• relational database systems
• object oriented database systems
• big data systems
• new types of database system
• big data management systems
• NoSQL database management systems
• Advantages of Database Systems
• reduced data redundancy
• improved data integrity
• efficiently shared data
• relatively simple development
• access database components
• tables
• queries
• forms
• reports
• macros
• modules
• visual programming (visual basic)
• relational database
• the entity-relationship model
• entities (objects)
• students, classes etc.
• relationships
• enrollment ( student to classes)
• types of relationships
• one-to-one
• one-to-many
• a design example
• creating tables to capture a database
• querying the tables and the database
• query by example
• query language
• SQL is the most popular query language
• other database models
• objects oriented database model
• contains code and data
• multidimensional database
• in comparison, relational database is a two-dimensional database
• web database
• back end database to a fron-end web serve
• big data
• NoSQL
• database personnel
• database analyst
• database adminstrators
• database users
• big data analyst
• other database terms
• data warehouse
• data marts
• data mining
• big data
• the processing of large amount of data
• facebook
• supermarket customer data