RDBMS - SEMESTER 3 - EPIC VIDEO - FULL SUBJECT EXPLANATION VIDEO - BACKLOG EXAMS APRIL 2026 ||

Added: 2026-05-05

[00:00:09]In unit number one, the first important question is three level architecture.

[00:00:14]Okay, it is also known as ANSI SPARC architecture. ANSI SPARC architecture and three level architecture and okay.

[00:00:23]Question is same. Okay? The three level architecture of DBMS is used to describe the structure of a specific specific database system. Means the data which is stored in the database I think three levels like a divided and only and then keep three level architecture and you can pay attention okay now. ANSI ANSI stands for American National Standard Institution. And SPARC. What it is defined means it stands for Standing Planning Agency Research Committee. S and the standing P and the planning A and the agency R and the research search and committee.

[00:01:01]So this is the organization name ANSI SPARC. Okay, that is a full form.

[00:01:06]>> [snorts] >> What it is describing? It is describing the data in three levels. Data abstraction and it on though data whatever the data we have splitted in the database it is divided into three types. Okay? What are the three types? External level, conceptual level and internal level.

[00:01:25]Three types like it is divided.

[00:01:27]External, conceptual and internal. This three you need to remember and you need to explain it separately. Okay? Diagram what you are having see the database you are having no kinda below.

[00:01:40]Database. That is the database where everybody's data is stored there. Okay?

[00:01:47]That is database. Next internal level you will have. Next conceptual level you will have. External level. We are the viewers right?

[00:01:55]Okay, if in case Google away if you are searching anything in Chrome.

[00:02:01]You're searching anything about bag or books or something you're searching. In external level only we need to able to see that.

[00:02:08]You can adjust some.

[00:02:10]Whatever the views you are having view one, view two, view three whole data we are not able to see.

[00:02:16]Just only the data in the external level. External level is the top level.

[00:02:21]We see only the top level. The bottom level we should not see. We are not authorized persons to see.

[00:02:27]When you are search your results you will get your own results only. You'll able to you should not able to see other results if you are not having their hall ticket number, right?

[00:02:36]That is the external level.

[00:02:38]Okay?

[00:02:39]Conceptual level is nothing but external level level and the conceptual level.

[00:02:48]No, only till here we able to see. For example in your college in in your college database you are having they are having the students information, faculty information, fees and the collected only how much they are paying salaries everything is stored in that database in your college. Will you able to check your faculties salary?

[00:03:08]You are a authorized person? No. We are able to check only your things. Your information only. About your fees, about your identity card, about your things only. That is the external level. Who will see conceptual level? The persons who is non-management non-teaching staff will be there no accounting staff. They will see.

[00:03:29]Means they are the higher authorities rather than external level. So they will see the conceptual level. I think the database access only for that. Only up to the principal room I can go and tell them. Principal chair I can sit there.

[00:03:44]No, means conceptual level is nothing but more authorized person except external level and all.

[00:03:51]Internal level means database direct level then the next level is internal level.

[00:03:58]Okay? So principal is the owner of the college.

[00:04:02]So he or she has the full access about the student, about the teaching faculty, about the non-teaching faculty, everything.

[00:04:11]So she can access the database, right?

[00:04:13]So these are the three levels which you are having in three level architecture.

[00:04:18]Okay? Uh compulsory you need to draw the diagram.

[00:04:24]Next you are having DBA.

[00:04:27]Who is DBA and what are his or her role and functions? DBA stands for database administrator.

[00:04:35]Means what the DBA will do means the overall database what they are having it will administrated by him or her.

[00:04:43]Means all the access he will take care of the database. In every organization some of the other people will be having for to secure the data no?

[00:04:53]I don't know what a data story is going to happen then the access the any kind of information what I want to know what I want to know that.

[00:05:00]What I want to know database administrator and all. What this database administrator will do means all the activities whatever you are having in your organization, whatever the activities you are running in the organization will be managed by DBA.

[00:05:14]I mean information you are working in information pass you are working in information you have a good check this over all. DBA.

[00:05:22]Okay? So DBA is responsible for installing database software.

[00:05:28]Any type of new software if it is required to the organization for the database he need to tell the installation purpose.

[00:05:36]He need to install he need to take see the all the technical things whatever the things you are having about the database he need to handle about that.

[00:05:43]Okay? So there are very rare chances that a single person cannot manage overall database.

[00:05:51]In many organization in MNC companies uh lacks of the customers data they need to store. Single person can't do that all no? So database administrator and every organization minimum three to four members work and all that.

[00:06:08]Rare I don't know what I handle just like that. Even if you are having any small scale industries at that time DBA is a single person who can manage all the activities of the database.

[00:06:20]Okay? This is the introduction of database administrator.

[00:06:24]What are his roles? What he need to do as a database administrator?

[00:06:28]Data security, data privacy and data integrity. He need to secure the data.

[00:06:34]He need to keep it privacy private.

[00:06:38]He need to keep it private and he need to keep integrity. Integrity is nothing but correctness.

[00:06:44]Responsibilities. Roles is nothing about the responsibilities of a DBA.

[00:06:49]Okay? Next database backup and recovery.

[00:06:52]If in any case data is lost means he is the responsible person who need to backup the data and he need to responsible to recover the data. Right?

[00:07:03]Next managing data integrity. Data integrity is nothing but protecting the database from unauthorized users.

[00:07:12]If any unauthorized users is trying to access the data he need to be alert to rectify that.

[00:07:20]That I can tell you how you can just put them organization up. Owner to check this data and every time. I just want to know who is authorized person, who is not authorized person and all.

[00:07:32]Next capacity issues. Database they will have some capacity issues. In our phones also 256 MB, 256 GB, 120 GB, 120 and all that. So sometimes database capacity and means the ability to store the data is there or not also it is his responsibility to check that.

[00:07:54]Okay?

[00:07:55]Next database accessibility. Database accessibility means nothing about the he decides who need to access the data.

[00:08:05]Okay? Database administrator decide just now.

[00:08:08]You are able to access this data and all. You are able to access this okay now. Next provides help and support to the user. Any case of if you are not understanding anything about the data he need to guide you.

[00:08:22]Okay? He need to help to and support the user whatever the complications you are facing.

[00:08:29]What support you some support customer support like that. Okay? What are the functions? Here I'm wrote I have wrote only five functions. You need to elaborate it in your examination. For example communicating with users. This is the side heading.

[00:08:44]Okay?

[00:08:45]What is communicating with users? He will communicate that is database administrator will communicate with the users. Without communication how can he give access to the users?

[00:08:57]I don't know what you want to know that you should know.

[00:09:00]What you want to know that you should know.

[00:09:02]That is the communication with the users. Morning.

[00:09:06]I bought it to do.

[00:09:09]Eight marks.

[00:09:11]Roles and functions if they are asking means in roles any four points in functions any three points.

[00:09:18]My thing is one side page one page you need to write it. Whether you are writing two points or three points or four points doesn't matter. But I'm explaining everything. Okay?

[00:09:28]Monitoring performance. Monitoring performance for example separate person security CC camera surveillance just to do.

[00:09:38]He will monitor all the activities a floor that you want to do and all. Same like that only in database administrator also is responsible for monitoring the performance.

[00:09:48]Approving data access.

[00:09:51]Okay? If somebody is trying to logging to your database he need to approve it.

[00:09:58]Uh you want Approving data access means who is asking to access the data, he need to approve it.

[00:10:13]I don't know. Same like that.

[00:10:15]Regular backup. It is his responsibility to do backup.

[00:10:24]of any data lost We can backup that. Okay? Next, authorizing the users. Authorizing the users means whether the user is the authorized person or not. When you try to log in your email in my phone means they will ask your email ID along with the password. Without password you will you log in to your email in my phone?

[00:10:44]No.

[00:10:45]That is like authorizing the users.

[00:10:48]Okay?

[00:10:49]Next.

[00:10:51]Third question. What is the advantages and disadvantages advantages of database management system over file-based system?

[00:10:59]What is DBMS? This Whatever the DBMS we are having, how it is useful? What are the advantages of it?

[00:11:06]See, simple thing.

[00:11:08]It reduces the data redundancy. What is data redundancy? Two marks it is important. Duplication of data.

[00:11:18]>> [clears throat] >> What is data redundancy?

[00:11:23]Duplication of data.

[00:11:31]Data redundancy is nothing but having the same data in multiple times.

[00:11:42]That is called data redundancy. It reduces the data redundancy when you are having DBMS.

[00:11:47]Data consistency.

[00:11:49]Consistency is nothing but quality of data. Uh you need to elaborate that.

[00:11:53]These are only side points that I have wrote. In examination you need to elaborate that.

[00:11:59]Okay?

[00:12:01]Data consistency means quality of data.

[00:12:03]How much data is required to our organization? That is called data consistency.

[00:12:10]Okay? Next, data sharing.

[00:12:12]It will share the documents through database. Quality, productivity, it will reduce the time when you are having a DBMS.

[00:12:20]Okay? Easily maintenance, backup, whatever the things we have discussed just now, you can include all that points over here also.

[00:12:35]The in that case only DBMS I like it.

[00:12:38]Okay?

[00:12:45]It will share the documents from one computer to another computer.

[00:12:52]ER model.

[00:12:54]ER stands for entity relationship model.

[00:12:57]Okay? What this entity relationship model means? It will show the data in a flowchart using the diagrammatics.

[00:13:07]Okay? I am explaining the all questions.

[00:13:10]What are the two questions I have said?

[00:13:11]If you are preparing the two questions, it will be okay.

[00:13:27]ER model. ER model What is means? Entity relationship model.

[00:13:39]For example, when you open your settings, okay, option option means data is showing in a format.

[00:13:50]Structure of the thing. That is called entity relationship.

[00:13:54]ER.

[00:13:55]So in the entities and entity real-time entities. For example, person, car, employee, names and any Okay? Next.

[00:14:10]Student customer job student customer job we can store the data. No? That is called entity.

[00:14:19]What is attributes? Attributes is nothing but describing the whatever the things is there.

[00:14:40]You want any you want any relationships and matter.

[00:14:42]So entity student.

[00:14:45]The relationships number ID card hall ticket you want any.

[00:14:51]Hall ticket number identity card.

[00:14:54]Uh phone number age of these okay? So different diagrams attributes and then Student and then date of birth and then Age you want any college age date of birth cast and any.

[00:15:14]Okay? Relationship. Student course and then like relationship and then any type of diagrams use here.

[00:15:22]First you are having see components or symbols in ER diagrams and then You can use rectangle. That is called entity set and then Ellipse and then and then good shape and then any.

[00:15:44]Ellipse and then Uh oval shape and then okay? Then attribute and then okay? Diamond shape and then relationship and then Line.

[00:15:57]Double ellipse double line double rectangle.

[00:16:01]It's a different types of symbol use here. ER model data and then store here.

[00:16:08]So too.

[00:16:10]No [clears throat] no need of doing elaboration. See.

[00:16:13]So you need one ER model DBA important.

[00:16:17]Three sorry. ER model three level architecture important. Okay?

[00:16:25]Our two perfect and then DBA curriculum.

[00:16:29]Three level architecture.

[00:16:32]You want any important.

[00:16:36]Unit number two only one topic normalization. Normalization Normalization is a compulsory question then no need to go with the file organization. Okay?

[00:16:48]Compulsory normalization question which is of eight marks. Two marks also you can include So for example, what is normalization? What is normal form? One and a half two and a half short total 10 marks weightage. Okay? What is this normalization? Normalization is a technique of organizing the data in a database.

[00:17:10]Okay?

[00:17:11]Normalization data database store what are the techniques use this time?

[00:17:18]Any techniques use this time? It is a systematic approach of decomposing table. Decomposing dividing the table.

[00:17:27]Okay? A data database store various techniques use this time.

[00:17:33]First a data required data store okay?

[00:17:39]The process of normalization includes various normal forms. One and a half second normal form third normal form voice code normal form fourth fifth only.

[00:17:50]Only fourth fifth my syllabus exam you can do here.

[00:17:54]Not in syllabus and then >> [laughter] >> Think but there but nobody is using that normal form and then First normal form. First normal form what are the rules we need to follow?

[00:18:18]Repetition of groups okay? Rules compulsory you need to mention it. Okay? So you can answer just you need to remember the tables.

[00:18:28]If you remember the tables no need to remember any answer rules first normal form repetition of the groups and then repeat okay? And then repeat okay?

[00:18:42]Second one primary key identify third one dependence and then one.

[00:18:47]For example, example employee number employee name month sales.

[00:18:54]Employee number one.

[00:18:56]Okay? Name and then Sales January February if first employee two times repeat okay?

[00:19:07]Means a person two times data repeat okay?

[00:19:11]That is called decomposing before decomposing table one and a half one and a half first one repetition of the groups and then name law A pair and then employee ID one only. ID and sales month sales so decomposing employee number one and then name January and then sales one and then name February and then sales.

[00:19:41]I don't know difference you are having.

[00:19:46]A cell row just column column cell name only.

[00:19:53]Okay? One and a half convert and then Second and if 2 and if What is normalization and then I'll go one two three BC and if not explain that Fast fast and I am up I don't mind that.

[00:20:29]I don't know.

[00:20:30]I force it to the syllabus later.

[00:20:33]Okay now I can Ah.

[00:20:37]I don't mind that. 2 and if 2 and if channel and if what are the rules it should be followed means table should be in one and if table that it first normal finish and I can I can I can I second normal from J because they But the non key attribute and if it fully dependent on the money See example employee number on the employee name on the month sales bank number bank name.

[00:20:59]Okay now I can I can I can employee number go to employee ID go to employee name that is today.

[00:21:05]Employee ID go to employee a month later she do that is today. Employee name go to employee a month later she do that is today.

[00:21:12]Employee name employee ID go to bank number that is today.

[00:21:18]The whole ticket number go to the bank number that is today.

[00:21:21]Tell me. So you can primary key and then the employee number and put them on either employee ID go to the money money money I don't know you know what I mean.

[00:21:33]Bank number I put the money account number go to the bank number that is today.

[00:21:37]Okay now I can I can I can bank is depending bank name is depending on bank number.

[00:21:44]Bank name and the bank number made I don't know I don't know and if two tables they are I put the money bank number I don't mind that. Bank number Bank number go to the bank number that is today. I don't think I need my ID go to the bank number that is today.

[00:22:00]Understood I can I can I can First normal from the first I don't know that.

[00:22:09]I don't know that.

[00:22:10]>> [laughter] >> I don't know the bank number go to the student whole ticket number that is today.

[00:22:14]I don't know that.

[00:22:16]Okay.

[00:22:17]2 and if the two tables today I don't know what to do I don't know. 3 and if the three tables today I don't know what to do I don't know.

[00:22:24]I don't know that I don't know that I don't know that I don't know that. X Y Z and I I don't know what to do I don't know.

[00:22:31]When you are doing third normal form table and if second normal from the money it should not have transitive dependencies and then example to the money company city state zip zip and then the pin code Okay now I put company name go to company city I don't know what to do I don't know.

[00:22:49]A city is in the money company name go to the state in the money I don't know what to do.

[00:22:59]I don't know what to do I don't know company and I don't know what to do.

[00:23:01]Okay okay.

[00:23:02]Okay. I don't know company name go to the money pin code that is today.

[00:23:07]I don't know that. Company pin code pin code I don't know what to do I don't know.

[00:23:16]I don't know what to do I don't know what to do I don't See. I don't know company I don't know city name go to the money pin code I don't know what to do I don't know.

[00:23:38]I don't know what to city name go to city go to the money state I don't know what to do I don't know.

[00:23:44]Pin code I don't know what to do I don't know. So three tables I don't know BC three and I don't know what to do I don't know me tables I don't know what to do I don't know hello hello hello exam though tables I don't know what to do I don't know. Explain this I don't know what to do I don't know first two two points I I don't know what to do I don't know.

[00:24:04]Tables I don't know what to do I don't know any tables I don't know what to do I don't know one nation that 2 and if Okay.

[00:24:12]Boyce card normal from and the table should be in 3 and if third normal from the money functional dependency key primary key and if you don't know and then I'll go I don't know what to do. I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to I don't know employee number employee nationality department type department number only I don't know employee number go to employee nationality I don't know what to do.

[00:24:35]I don't know what to do I don't I don't know that.

[00:24:38]Employee number go to employee nationality I don't know what to do.

[00:24:43]Employee department sales are production department number go to the money Okay. Next Employee ID go to the money employee department I don't know what to do. I don't know what to do I don't know BC and if the four tables today.

[00:25:01]one one two three four I don't know what to do I don't know what to do I don't know what to do I don't know what normal I don't know what to do I don't know.

[00:25:13]I don't know what to do I don't know.

[00:25:16]I don't know that.

[00:25:19]Okay. This is the second unit.

[00:25:23]unit though SQL commands and if you don't know only SQL commands you need to be perfect. In SQL commands there are four types of commands.

[00:25:32]DDL DML DDCL DCL and then what is specific they are asking only DDL means only DDL explain that.

[00:25:44]DCL I don't know what to do I don't know.

[00:25:46]Only my explain that. Okay.

[00:25:49]Only SQL commands explain that I don't know what to do I don't know explain that.

[00:25:53]Okay DDL DML DDL DML my explain that.

[00:26:01]DDL data definition language and then I don't know what to do. I don't know what to do create alter drop desk rename create a table only I don't know what to do I don't know what to do I don't I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know I don't know what to do I don't know what to do I don't know what to do I don't know table name rename syntax create a table create a table This command is used to create a table.

[00:26:28]I don't know what to do. syntax and if create table table name create table and I don't know what to do.

[00:26:35]example and I don't know what to do create table dolly and I don't know what to do I don't know what to do I don't know.

[00:26:39]table name I don't know what to do.

[00:26:43]customer ID customer name student ID student name Okay now alter alter and if you don't know it will modify the table. I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know. What is the syntax of that alter table table name?

[00:26:58]alter table and I don't add age and I don't know what to I don't know what to do I don't know I don't know what to do I don't know what to do.

[00:27:07]Okay. simple ma Okay example example I don't know what to do.

[00:27:12]You are admission this could college love it. same one love What language is choose this quantity I don't know what to do I don't know what to do I don't know what to do I don't I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do [clears throat] I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to [cough] do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I don't know what to do I in the world in the money Below 5 Automatically Money students Update and modify any value same.

[00:30:04]Delete and delete jail.

[00:30:06]Okay.

[00:30:09]DCL Grand and real Grand Permission Access Real Deny Example Okay. DCL Rollback save point DML DDL Important DCL DQL Okay. Unit number three You are having unit four. One question.

[00:30:41]Unit four Database security Database Integrity Database recovery General topic this is.

[00:30:49]How I am saying general topic? Database Security Security Inca Fingerprint Inca Face lock Inca Different types of securities Provide Same this type Security Do for Database Database Nothing Policies Programs Where Used to secure Our data Okay.

[00:31:16]So physical How can we can Like for example Physical Physical Computer System Information They protect Choose the number For example Any unauthorized Users Use Like email Passwords Ask no That is Type of security Someone Trying Log in to your Email I don't know.

[00:31:49]I think physical Type of Data security Human To avoid the information leakage Human And the money Information Secret Data Privacy We don't know.

[00:32:04]He may tell to others also.

[00:32:06]Through that also data can be lost.

[00:32:08]Leakage Yes. Operation system Operation system is nothing but Unauthorized Users They are trying Access the data That time Operation System Next network I think my network Network Through Data Transfer Message It will Through the Network Signals Signals Money money I don't know.

[00:32:36]So Network Just say You are Hackers Network Hack I don't know. I network Network Device Connected I don't know.

[00:32:44]Data Network Data Leakage Wi-Fi I don't know. Wi-Fi Bluetooth Okay.

[00:33:02]Database system Recovery Data Data Lost How you can recover your data?

[00:33:15]Email Backup Backup Recovery Techniques Backup I don't know what to do.

[00:33:23]I don't know.

[00:33:24]Backup Restore Restore Backup When you Backup Get to restore Your data I don't know what's up.

[00:33:35]I don't know.

[00:33:36]Transfer Backup That is called database recovery.

[00:33:44]Database Security Fingerprints Passwords Secrecy Integrity Availability Integrity Integrity Correctness Data Only I don't know.

[00:34:10]I don't know.

[00:34:12]Security I don't know.

[00:34:16]I First two questions Question Third question Second question Backup Recovery Techniques Backup Backup Backup Recovery For example Once Photo Delete Recycle I don't know.

[00:34:41]I don't know.

[00:34:43]I don't know.

[00:34:44]For example Delete Deleting Option I don't know.

[00:34:55]I don't know. Backup Recovery Techniques I don't know what to do.

[00:35:02]I don't know. of technique Recovery Next I don't know what to do. I don't know.

[00:35:12]Forward Recovery Technique Forward Recovery Techniques Like Delete Photos Apps Recovery Dumpster Permanent Delete My files Store Trash Delete Photos Recovery Whatever Okay. So this About Fourth unit Any doubts?

[00:35:49]Unit number five The first Topic DDBMS What is DBMS Is nothing but Distributed database Management System Distributed Whatever The data Having Organization It is Distributed To the Management Okay. So What happened? This is the database Of the whole organization Organization For example College Student Faculty Teaching So It will distribute the data. Student Access Student Data Teachers Access Teachers Student Data I don't know. Data Distributing Different I think database Administrator I don't know. Data Data Distribute I don't know. Access Okay. Distributed Database Management System This diagram I don't know.

[00:36:55]Okay. So what Advantage DDBMS Means Faster Access Data Faster Data Faster Access I don't know.

[00:37:07]See student Data As Student You can access Easily Whatever The thing Want The Information Okay. So Easily Access Faster Data Processing Data Processing Loading Loading time Okay. Two two Lines Easily you can I don't I don't know.

[00:37:45]Data Access Nothing but Data Can access By Various Organizations About Information Next Improved Communication When you Data Distributed Limited Data You can Communicate The data I don't know.

[00:38:00]Easily Next Reduced Operation Cost Operation Cost Nothing but Time consuming Operating I don't know. Time Consuming Like Wi-Fi Internet Use I don't know. Cost Next >> [snorts] >> Friendly Interface User Friendly interface System Easily I don't know.

[00:38:31]I don't Technical Technical I don't know.

[00:38:36]Website Order Interface Easily I don't know. I don't know.

[00:38:42]I don't know.

[00:38:43]Payment I don't know. Can be easily User Friendly Interface Disadvantage Technical Complexity Management Control E database Distributed Database Management System Control Complexity I don't know.

[00:39:02]I don't know. I don't know. I don't know. I don't know. I don't know.

[00:39:05]It is com Complicated To understand And this The data Next Technologically Difficult Means She To do More Technological Means Technical Value Be Uploaded I don't know.

[00:39:18]I don't know.

[00:39:20]C++ I don't know.

[00:39:22]Technical Difficult Understand Okay.

[00:39:26]Security Sometimes May Be there.

[00:39:30]Okay.

[00:39:31]Next Lack of standards Lack of I don't know. Up to Technology 2020 Type Capacity Phones 5G Like this called lack of standards.

[00:39:50]Okay? Increased storage and infrastructure requirements. And then it will be not possible in DDBMS.

[00:40:00]Limited storage capacity only will have.

[00:40:03]Next, increased training cost. Training It is a major disadvantage.

[00:40:12]Right?

[00:40:12]So, that is the thing about the DDBMS.

[00:40:15]Last year the DDBMS is a question of client-server architecture and a question.

[00:40:20]Client-server architecture DDBMS architecture Client-server architecture and DDBMS architecture Client-server architecture and DDBMS architecture DDBMS architecture architecture Elaborate diagram diagram Client-server architecture Client-server architecture architecture Architecture and database and architecture Client-server architecture and client-server database and architecture So, if client and the we are the clients.

[00:41:01]Server and the entity database When you are typing when you are searching an information in the Google or the Chrome We are doing a We are asking for the question.

[00:41:18]Client is asking the question it is responding.

[00:41:23]Okay, now. Danny Server and the database we handle you say that.

[00:41:27]When direct the database handle you am middle of the person under the body server.

[00:41:32]Oh, no.

[00:41:33]Person and the real money got it.

[00:41:36]But in Google the most of the data on the tons of money billion tons of data on the on the phone on the phone on the It such is the other one such that I don't know how to handle this entity server.

[00:41:48]>> [laughter] >> Google server server Yeah, Google and game fun in my life.

[00:41:57]Okay, now in the last single time two time three time and time in the different types of server systems and the different >> [cough] >> infinite Okay, now.

[00:42:07]Single time and the okay client okay server.

[00:42:10]May be the question I ask you you may be the one to answer me.

[00:42:14]That is single time and time So, in the diagram server dash ready.

[00:42:21]So, server is asking client is asking.

[00:42:23]response Client is asking server is responding.

[00:42:28]Single time Two time and the for example >> [snorts] >> Okay, okay server now.

[00:42:33]It's server now.

[00:42:35]Okay, now client now.

[00:42:37]So, We need the information Okay, now Danny two time architecture architecture Three time and the Okay, three different part three different parts of the computer is asking different types.

[00:42:56]Oh, no. But in the organization but in my college and in the labs and the color labs Computers and the connect and the main device key Oh, no. Okay, main device and the income and the normal device and the Normal devices and the main device and the main device and the main device Same Danny Three time and the entire and the entire And the client-server architecture and the client-server database and the database Uh Three different parts middle of the database server is called Same Uh Entire diagram and the entire Okay, now.

[00:43:34]I don't know DDBMS and the client-server and the client-server and the perfect and the client-server.

[00:43:41]Entire diagram