DBMS

   DATABASE MANAGEMENT SYSTEM   

Database: A database is a collection of related data which represents some aspect of the real world. A database system is designed to be built and populated with data for a certain task. (DBMS) refers to the technology for creating and managing database. 

Database Management System (DBMS) is a software for storing and retrieving users' data while considering appropriate security measures. It consists of a group of programs which manipulate the database. The DBMS accepts the request for data from an application and instructs the operating system to provide the specific data. In large systems, a DBMS helps users and other third-party software to store and retrieve data.

Database management systems were developed to handle the following difficulties of typical File-processing systems supported by conventional operating systems. 

1. Data redundancy and inconsistency 
2. Difficulty in accessing data 
3. Data isolation – multiple files and formats 
4. Integrity problems 
5. Atomicity of updates 
6. Concurrent access by multiple users 
7. Security problems

ER DIAGRAM (Entity Relational ) :- 
  1.  ER diagram or Entity Relationship diagram is a conceptual model that gives the graphical representation of the logical structure of the database.
  2. It shows all the constraints and relationships that exist among the different components. 
  3. An ER diagram is mainly composed of following three components- 
  •         Entity Sets,
  •         Attributes 
  •         Relationship Set.
 Roll_. no is a primary key that can identify each entity uniquely. 
 Thus, by using a student's roll number, a student can be identified uniquely

Entity Set :  An entity set is a set of the same type of entities. (a thing with distinct and independent existence.)


● Strong Entity Set: 
  •    A strong entity set is an entity set that contains sufficient attributes to uniquely identify all its         entities. o In other words, a primary key exists for a strong entity set. 
  •     Primary key of  a strong entity set is represented by underlining it. 
● Weak Entity Set: 
  •    A weak entity set is an entity set that does not contain sufficient attributes to                                   uniquely identify its entities. 
  •   In other words, a primary key does not exist for a weak entity set. 
  •   However, it contains a partial key called a discriminator. 
  •   Discriminator can identify a group of entities from the entity set.
  •   Discriminator is represented by underlining with a dashed line. 











 




Comments

Post a Comment

Popular posts from this blog

the distance between two cities (in km is input through the keyboard. write a program to convert and print this distance in meter ,feet inches and centimeter.

11 . The distance between two cities (in km is input through the keyboard. write a program to convert and print this distance in meter ,feet inches and centimeter. package com.company ; import java.util.Scanner ; public class Main { public static void main ( String [] args ) { // write your code here System . out . print ( "Enter distance between two cities : " ); Scanner sc = new Scanner ( System . in ); //sc is scanner name double distance , meter , feet , inches , centimetres ; //variable is declared distance = sc . nextDouble (); //taking input from user (in km) meter = distance * 1000 ; //1km = 1000m feet = distance * 3280.8399 ; //1km = 3280.8399; inches = distance * 39370.0787 ; //1km = 39370.0787; centimetres = distance * 100000 ; //1km = 100000; System . out . println ( distance + " kilometer = " + meter + " meter" ); System . out . println ( distance + " k
Read more

CREATE UNIT CONVERTER APP

Image
CREATE UNIT CONVERTER APP USING XML AND JAVA IN ANDROID STUDIO xml code :- <? xml version ="1.0" encoding ="utf-8" ?> < androidx.constraintlayout.widget.ConstraintLayout xmlns: android ="http://schemas.android.com/apk/res/android" xmlns: app ="http://schemas.android.com/apk/res-auto" xmlns: tools ="http://schemas.android.com/tools" android :layout_width ="match_parent" android :layout_height ="match_parent" android :background ="#F8E753" tools :context =".MainActivity" > < EditText android :id ="@+id/editTextTextPersonName" android :layout_width ="wrap_content" android :layout_height ="wrap_content" android :ems ="10" android :inputType ="number" android :textColor ="#E91E63" app :layout_constraintBottom_toBottomOf ="parent"
Read more

write a program to check whether a triangle is valid or not, when the threeangles of the triangle are entered through the keyboard. A triangle is valid if the sumof all the three angles is equal to 180 degrees

  /*write a program to check whether a triangle is valid or not, when the three angles of the triangle are entered through the keyboard. A triangle is valid if the sum of all the three angles is equal to 180 degrees. */ package com.company ; import javax.security.sasl. SaslClient ; import java.util.Scanner ; public class Main { public static void main ( String [] args ) { // write your code here int a , b , c , sum ; //angle of triangle Scanner angle = new Scanner ( System . in ); System . out . print ( "side a : " ); a = angle . nextInt (); System . out . print ( "side b : " ); b = angle . nextInt (); System . out . print ( "side c : " ); c = angle . nextInt (); //sum of angle of trinagle sum = a + b + c ; if ( sum == 180 ) { System . out . println ( "Triangle is valid" ); } else System . out . println (
Read more