Wednesday, February 28, 2024

SEATWORK


INFORMATION MODEL & DATA MODEL

The Information Model is a formal and concrete definition of the structure of information. It talks about how information is arranged in a certain area. It describes the information's relationships, how they are related, and what their important parts are. 
Data Model on the other hand, is the more detailed version of the previous information model. It's where we exactly clarify how to structure and store data in a database. It provides which data complements each other and how they relate to each other.

 
NETWORK MODEL
The Network Model organizes data in a network of points connected by lines. Each point represents the history or records while the lines show how these records are linked. This model lets records have more than one connection.

RELATIONAL MODEL
The Relational Model is organizing data in a much more simplistic way using tables, rows, and columns. These rows contains information while each column contain a different detail about the said information. Lastly, these tables can be linked together and can be related. 

HIERARCHICAL MODEL
The Hierarchical Model puts data in a tree-like structure. There is a root information which splits into smaller points which can also split into even smaller ones. Like a family tree, it provides clarity by having a clear order. However, its downside is that it's not for complicated stuff.

Saturday, February 10, 2024

LEC : DISADVANTAGES OF DBMS

Disadvantages of using a Database Management System (DBMS) include the initial setup and maintenance costs associated with implementing and managing a complex system. Additionally, DBMS may require specialized training and expertise to effectively operate and troubleshoot, which can increase operational overhead.

 

LEC : ADVANTAGES OF DBMS

 


Advantages of using a Database Management System (DBMS) include centralized data management and improved data security, ensuring data consistency and protecting sensitive information. DBMS also enhances collaboration and enables efficient query processing for improved system performance.

LEC : FUNCTIONS OF DBMS

 


The function of a Database Management System (DBMS) is to provide a software platform that enables users to define, create, manipulate, and manage databases. Its main functions include data storage, data retrieval, data manipulation, data security, concurrency control, backup and recovery, and data integrity enforcement.

Friday, February 9, 2024

LAB: THINK OF ATLEAST TWO DIFFERENCES BETWEEN ACCESS AND EXCEL..

Excel is primarily a spreadsheet program that allows users to organize, analyze, and manipulate numerical data. It excels (pun intended) at performing calculations, creating charts and graphs, and conducting complex data analysis.



Access is a relational database management system (RDBMS) that focuses on storing, organizing, and retrieving large amounts of structured data. It provides a user-friendly interface for creating databases with tables, forms, queries, and reports.

LAB: WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS?


Microsoft Office Access is a relational database management system (RDBMS) software developed by Microsoft. It is part of the Microsoft Office suite and is designed to help users create and manage databases.



Microsoft Office Access is a relational database management system (RDBMS) software developed by Microsoft. It is part of the Microsoft Office suite and is designed to help users create and manage databases.

LAB: WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL?


Microsoft Office Excel is spreadsheet software that falls under the category of spreadsheet applications. It is a part of the Microsoft Office suite and is widely used for tasks involving data analysis, calculation, and organization.



Excel is commonly used for tasks such as financial modeling, budgeting, and statistical analysis. Its versatility makes it a valuable tool for individuals, businesses, and organizations seeking to manage and analyze data efficiently.

Thursday, February 8, 2024

LAB: WHAT IS A DATABASE?


A database is a structured and organized collection of data. Its purpose is to provide an efficient and reliable way to store, manage, and retrieve data.

It offers a scalable and flexible solution for handling vast amounts of information. a database acts as a digital backbone, supporting applications and systems that rely on organized and accessible data

XML, JSON, AND AJAX

XML is a language called eXtensible Markup Language. It's a way to format documents so that both humans and computers can read them easi...