weekly
husker26
WEEK3456.docx***WEEK 3***
Before the computer, most information was stored in paper form. When we needed information, we used to search through the papers. If we knew a date or category of the information we were searching for, we would go to that section in the papers. When we wanted to update or delete some data, we searched for it and modified them or struck them off. If the data is limited, then all these tasks are easy. But imagine library information, information about a student in a school, or banking system data! How do we search for specific required data in papers? It can be a never-ending task! Computers help solve this problem. Research the evolution of file system data processing.
Discuss the evolution of file system data processing and how it is helpful to the understanding of the data access limitations that databases attempt to overcome. Also include your understanding of data and information.
Engage the following resource(s) to get started.
Reading(s)
File Organization Techniques
https://smallbusiness.chron.com/file-organization-techniques-545.html
Video(s)
Computer Skills Course: File Management, Part 1
https://www.youtube.com/watch?v=k-EID5_2D9U
****WEEK 4****
OLTP and OLAP are two of the common systems for the management of data. OLTP (Online Transaction Processing) is a category of systems that manages transaction processing. OLAP (Online Analytical Processing) is a BI (Business intelligence) tool. BI refers to computer-based methods for identifying and extracting useful information from business data. Research OLTP and OLAP.
Discuss the difference between online transaction processing (OLTP) and online analytic processing (OLAP), and their relationship with business intelligence, data warehousing, and data mining.
Engage the following resource(s) to get started.
Reading(s)
DBMS – Transaction
https://www.tutorialspoint.com/dbms/dbms_transaction.htm
DBMS – Concurrency Control
https://www.tutorialspoint.com/dbms/dbms_concurrency_control.htm
Video(s)
Fundamental Knowledge on OLTP and OLAP?
https://www.youtube.com/watch?v=fdeJjX2qygk
*****WEEK 5*****
SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Microsoft SQL Server, and Access. Most database systems use SQL, but most have their own additional proprietary extensions that are usually only used on their systems. Research SQL and answer the following:
What are the advantages and disadvantages of SQL? Discuss and demonstrate the basic mechanisms for accessing relational databases from various types of applications. Please provide examples as part of your explanation.
******WEEK 6******
In the entity relationship approach to modeling we analyze system requirements and classify our knowledge in terms of entities, relationships, and attributes. Entities are the things we decide to keep track of. For example, if one considers a system to support an educational environment, one is likely to decide that we need to keep track of students, instructors, courses, etc. Typically, entities are the people, places, things, and events that we need to remember something about. Entities and relationships have characteristics that describe them. For instance, the students may be described by the values for their names, ID numbers, and phone numbers. Consider a student named John whose ID number is 184 and his phone number is 283-4984. Research data modeling techniques and capturing information requirements.
Entity relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. Using this knowledge, explain the key reasons why entity relationship modeling is important, and determine at least (1) way in which it impacts the overall development of the database.
Engage the following resource(s) to get started.
Video(s)
Illustration on ER Model to Relational Tables- 1 | Database Management System
https://www.youtube.com/watch?v=Dggxri0iYLI
ERD #2 Mapping ERD to Relations
https://www.youtube.com/watch?v=xUhd-p5knmo
Entity Relationship Diagram (ERD) Tutorial - Part 1
