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

Phone Dictionary Application in c

Image
Follow on LinkedIn  Phone Dictionary Application in c Project Created by :  SHRADDHA NAND PANDEY SHUBHAM KUMAR PODDAR RAHUL KUMAR PRASAD KETAN GUPTA  #include <stdio.h> #include <conio.h> #include <string.h> #include <stdlib.h> #include <windows.h> struct person  // Structure is declared {     char name [ 35 ];     char address [ 50 ];     long int mble_no ;     }; void menu (); void got (); void start (); void back (); void addrecord (); void listrecord (); void modifyrecord (); void deleterecord (); void searchrecord (); int main () {     system ( "color 9f" ) ; // to color the screen     start () ;     return 0 ; } void back () {     start () ; } void start () {     menu () ; } void menu () {     system ( "cls" ) ; printf ( " \t\t **********WELCOME TO PHONE DICTIONARY*************" ) ; printf ( " \n\n\t\t\...
Read more

BITWISE OPERATOR

BITWISE OPERATOR package com.company ; public class Main { public static void main ( String [] args ) { //AND operator int x = 10 , y = 6 , z ; z = x & y ; //both bits should be 1 /* x y x&y 0 0 0 0 1 0 1 0 0 1 1 1 */ System . out . println ( "z=x&y : " + z ); //OR bitwise operator z = x | y ; //one of bits should be 1 /* x y x|y 0 0 0 0 1 1 1 0 1 1 1 1 */ System . out . println ( "z=x|y : " + z ); //XOR bitwise operator z = x ^ y ; //only one bits should be 1 /* x y x^y 0 0 0 0 1 0 1 0 0 1 1 0 */ System . out . println ( "z=x^y : " + z ); /*LEFT SHIFT operator * It will double the number by moving 1 place * Automati...
Read more