Unit – 3
Relevance of Data Base Management System
Q1) What is Database?
A1) A database is a list of linked data that reflects a real-world situation. A database structure is made to be created and filled with information for a specific purpose.
Q2) What is the concept of Database Management System?
A2) It is a programme for saving and extracting data from users while taking necessary security precautions. It is made up of a set of programmes that manipulate the database. The DBMS considers an application's request for data and instructs the operating system to supply the requested data. A database management system (DBMS) aids users and other third-party software in storing and retrieving data in large systems.
Users should build their own databases using a database management system (DBMS). The acronym "DBMS" refers to the database owner as well as other application systems. It serves as a connection between the data and the software programme.
Let's take a look at a basic university database. In a university setting, this document stores information about students, classes, and grades. The database is divided into five sections:
Q3) What are various sections of database?
A3) The database is divided into five sections:
Every professor's information is stored in the TUTOR register.
Q4) What is Database Management System Network?
A4) Each child may have multiple parents thanks to the network database model. It enables you to model more dynamic relationships, such as the many-to-many relationship between orders and components. Entities are arranged in a graph in this model, which can be reached through many paths.
Q5) Short note on Hierarchical and Relational Database.
A5) Model data is structured in a tree-like form in a hierarchical database. Data is organised in a hierarchical (top-down or bottom-up) fashion. A parent-child relationship is used to describe data. In a hierarchical database management system, a parent may have multiple children, but each child has only one parent.
Since it is one of the simplest DBMS models, relational DBMS is the most commonly used. The data in the rows and columns of the tables is normalised in this model. SQL is used to modify a relational construct that is contained in fixed structures.
Q6) Various applications of Database Management System.
A6) Various applications of DMS are-
Q7) What are the different stages of Programme Development Cycle?
A7) The below are the different stages:
1) Make a plan:
One of the most important stages of the SDLC is planning. It assists the user in planning the specifications, needs, schedule, expenses, work time, and tools that will be required.
2) Examine:
This is the second most important phase in the software development process. It is the stage in which the real problem is identified. To recognise and understand all of it's requirements.
3) Conceptualization:
Design is an essential aspect of the construction process. Designing the architecture, user interface, scripting, communications, and authentication are all part of it. You may also use a flowchart or an algorithm to build the work.
4) Put into action:
Writing the coding as you intended is the next phase in the programming development life cycle. A programmer must be familiar with a programming language and adhere to the rules; any breach of the law results in a mistake. Working on this may take a few hours, depending on the mission.
5) Evaluation:
This is a time-consuming process as well. This move entails testing the software, identifying any issues, and debugging it. You'll still need to test it on various operating systems to see if it's compliant with various platforms.
6) Have documentation:
Any software is worthless if it isn't well-documented. There are two forms of paperwork.
Machine for User Documentation Documentation is required.
All of these forms are needed for the program's operation and any possible guidance.
7) Routine maintenance:
Programs, like every other commodity, entail upkeep. If there is a potential need for adjustment after the installation.