Skip to main content

Newer Post or latest post

Li-Fi vs Wi-Fi: A Battle of Light and Waves

Li-Fi vs Wi-Fi: A Battle of Light and Waves Li-fi is a light fidelity device that supports only the infrared and other lighting systems to transfer the data to the device which is used to receive from the sender device. Wifi is a wireless fidelity device that supports the radio waves to transfer the data to the wifi device which is used to receive the wifi signals at the limited ranges due to the device version capacity. Introduction to the computer system and computer applications related topics are listed following below here: Li-Fi vs Wi-Fi: A Battle of Light and Waves Let’s discuss the computer system related topic and questions above listed and their answers are following below here: Li-Fi vs Wi-Fi: A Battle of Light and Waves There are some points on the computer system and data communication related to the topic of “Li-Fi vs Wi-Fi: A Battle of Light and Waves” following below here: Lifi based data communication system:- Li-Fi is a light based signal data transmission ...
Post a Comment

What is meant by "Schema" in Database management system?

What do you mean by "Schema" in Database management system?

What is schema?

The schema is basically the structure of the database to show in a logical and physical type of database structure in database management system. The schema is necessary to use in the database technology to understand the structure of database. Where in the logical level the schema express their logical terms in the structure of schema and in the physical level show their connectivity of the database and other network or conjunction of the computer system in the physical level. So, there are two types of level of schema to define the structure of the database in a different level or categories.

Schema in database

In this post I have to discuss about the introduction of Schema of database. Here are the points about schema in database given below.

  • The schema is a skeleton structure of database.
  • Schema shows overall structure of data items.
  • It also shows overall data and records and their relations in the form of skeleton structure which are stored in a database.
  • The schema describes the structure of the whole database.
  • It is also defines the characteristics of all records.
  • It also describes the future required fields and characteristics of the records.
  • It is a time consuming structure to create for database.
  • It is better for design a database structure and at the starting it is very careful to create the structure of database.
  • When creating the structure you can necessary to neglect the modification of future fields or attributes. The modification of fields or attributes in the database takes it later to create.
------------------------------------------------------------------------------------------------------------------------


I hope you from this topic “ What is meant by "Schema" in Database management system? ” and you can enjoy this informative post that i have published and provide you to the information technology or computer science related solution or questions/answers provided in the topic to study and happy learning 🙂
"I appreciate your attention to this topic! If you have any thoughts or questions, please feel free to share them in the comments below. Until next time, stay curious and keep learning!"

Labels:

Comments

Post a Comment

Popular posts from this blog

what are the function of the joystick and light pen?

Q 1. State the functions of a joystick and that of a light pen? Introduction to the joystick device, virtual or soft joystick tool, game controller, virtual or soft game controller and light pen topics are covered below here: Joystick What is the meaning of the joystick in computer? What is the joystick as a peripheral device in the computer system? What is main use of joystick in computer system peripheral devices? What is the purpose of the joystick in computer? What are the types of joysticks in the peripheral system for game purpose? What do you mean by analog joystick in peripheral system? What are the advantages of analog joystick device? What are the disadvantages or drawbacks of analog joystick device? What are the uses of joysticks? What are top 5 uses of joystick device in the computer system peripheral? Where is the use of joystick? How to connect the joystick for game in computer system? Can you connect the joystick to the laptop? Why do n...
Post a Comment
Read more

Types of Local Storage in Computer Systems

Describe the different types of local storage of computer systems? The local storage device is a type of memory for the user to keep a database file for a long time to access again and stored as a distributed offline database on the local storage. The local storage device can be pendrive, compact discs, dvd, floppy drive, HDD, SSD, memory card etc. The local storage needs to keep the valuable database file for the user to provide the lost database if suddenly deleted or formatted the whole drive of the computer system. Local storage in computer systems refers to devices or media that store data directly connected to the computer. There are several types, including Hard Disk Drives (HDDs), which use spinning disks and magnetic heads to store data; Solid-State Drives (SSDs), which store data in flash memory, offering faster access times and lower power consumption; and Hybrid drives, which combine elements of both. Other forms of local storage include USB flash drives, SD cards, and CDs/...
Post a Comment
Read more

Discuss the data replication on the distributed database system?

Discuss the data replication on the distributed database system? The data replica is a term that refers to the data replication means the copy of data into the servers distributed to access the copy of data. The data replication in a distributed database system is a term that provides the benefits for the user to easily access the data from the nearby server provided for the client user from the website. The data can be easily accessible from the server and provide the fast speed with reduces the latency of the data transfer to the client server such as:- if the user access the data from their smartphone device then the data will be fast to load because the nearby server provide the data replicated or copied of data to the user. Data replication in a distributed database system involves creating and maintaining multiple copies of data across different nodes or locations to enhance availability, reliability, and performance. It ensures that users can access data even if a node fails, re...
Post a Comment
Read more