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

Operating System Basics: Understanding How Your Computer Thinks

Operating System Basics: Understanding How Your Computer Thinks The operating system is a system software that provides the functionality of the hardware to use and operate it on the computer to get the output data or information for use depending on the users. The operating system supports the application software that provides another service on the computer system to give a solution from an application specific program. The operating system installed into the computer that stores all the database files into the storage device which is also used to access the memory location of files and information depends on the memory address. The operating system manages the resources of the computer that include the input resources, output resources, storage resources and other types of peripherals that are used to process the program of the operating system. An operating system (OS) is the core software that allows a computer to function by acting as a bridge between the user, applications, and...
Post a Comment
Read more