MIDTERM - LECTURE SEATWORK - JAVIER, JOHN IVERSON S.

INFORMATION MODEL


An information model is like a plan for organizing data, making it easier to understand and use. It helps us see how different pieces of information are connected. For instance, in a database, it shows how tables relate to each other. By using an information model, we can design better systems for storing and finding data. It's sort of like creating a map for how information should be organized and accessed. In short, information models help us manage data more effectively.











DATA MODEL

A data model is like a plan for organizing information so it will be easy to use. It puts data into groups called entities and shows how they're connected through diagrams. Entities are like collections of things, and attributes describe those things.  The model makes sure the data stays correct by checking that it's all linked properly. Plus, it lets us ask questions and get answers using queries, which are like requests for specific information from the data.

There are 3 majors' component of data modeling, structural aspect, integrity aspect, and manipulative aspect. Structural is a collection like person names, places or things. The integrity aspect, like referential integrity, makes sure that data references in a database are correct and accurate, stopping any accidental changes or deletions to linked data. The manipulative aspect in a Microsoft Access Database involves utilizing queries, which are requests made by users for specific information, resulting in the creation of new tables by extracting data from existing ones.















NETWORK MODEL

Is way of organizing and structuring data to show how relationships between entities. It uses nodes to represent entities and edges to show the relationship between them. Nodes can have several connections to other nodes, making the structure flexible. This model is useful when entities have many connections, or the data is highly interconnected. It's a popular choice for complex data storage because of its flexibility.











RELATION MODEL

Is a system of organizing data in database using tables, each table represent a specified entity or relationship. Relation models allow efficient storage and also backup of structured data. 












HIERARCHICAL MODEL

 Hierarchical models use a tree like structure to organize data in a database. It's started to top to bottom, at the top one is the parent and the bottom is the child nodes.  Each level contains categories represented by parent nodes, while child nodes represent specific data items or subcategories. 




Comments

Post a Comment

Popular posts from this blog

.THINK OF ATLEAST TWO DIFFERENCES BETWEEN ACCESS AND EXCEL

Image
  Data Structure : Access is made for handling databases that have different tables connected to each other. This helps keep data organized and easy to find. Excel, though, is more like a big table where you can put information in rows and columns. While Excel can do math and look at data, it's not as good at connecting different tables like Access can do. Functionality : Access is really good at helping with complicated stuff like organizing data, checking if it's correct, making forms to type in information easily, and creating special reports. It's great for jobs that need a lot of work with data, like keeping track of things in a store, remembering customer details, or following projects. Excel, though, is better at doing math, making charts, and looking at numbers. People use it a lot for things like making budgets, figuring out finances, or just making lists without needing to connect different tables of data.
Read more

Information Management - JAVIER JOHN IVERSON S.

Image
JAVIER, JOHN IVERSON S. BSSCS 1D  DATA DEFINITION LANGUAGE (DDL): The Data Definition Language ( DDL ) is a group of commands in SQL (Structured Query Language) that helps create, change, or remove database objects like tables, indexes, views, and rules. It's like the plans for building a house. It tells us how to make rooms (tables), what each room is for (columns and their types), and the rules for organizing things (constraints).  INTERACTIVE DATA MANIPULATION LANGUAGE (IDML): The Interactive Data Manipulation Language (IDML) is a set of SQL commands that lets us handle and change data in a database. It's like the tools we use to move, arrange, or clean furniture in a house. We can add new stuff (insert data), rearrange what's there (update data), remove things (delete data), or just look around (retrieve data).  EMBEDDED DATA MANIPULATION LANGUAGE (EDML): The Embedded Data Manipulation Language (EDML) means using SQL commands inside a programming language like C, ...
Read more

LEARNING TASK MODULE 6- JAVIER, JOHN IVERSON S.

Image
JAVIER, JOHN IVERSON S.                        INFORMATION MANAGEMENT BSCS 1D  XML , which stands for eXtensible Markup Language, is a flexible way of organizing and moving data in a structured form. It uses tags to show how data should be arranged in a document, so both people and machines can easily understand it. With XML, users can make their own tags and structures to fit their specific needs. Because it organizes data like a tree, with smaller parts fitting inside bigger ones, it's great for handling complicated relationships between different pieces of information. XML is used in lots of areas, like making websites, sharing data between programs, and setting up configurations, because it works on any system and is supported by many different programming languages and tools. JSON , which stands for JavaScript Object Notation, is a way to share data between a server and a web app that's easy and light. It looks a lot ...
Read more