Skip to main content

MySql Revision Tour


A database is a computer based record keeping system. generally a database is defined as a collection of data for a specific organization.
DBMS is a program that control creation, maintenance and use of a database. DBMS centrally stores the data that can be shared and accessed as common resource by all  DB users. The advantages offered by a DBMS are as follows.
  • Reduces data redundancy.
  • Reduces data inconsistency.
  • offers data sharing.
  • can be used for enforcing data standards.
  • Provides effective data security.
  • Maintains data integrity.
Different Data Models.
  • Relational Data Model- data is organised as tables . the tables are called as relations and each row in a table represent relation among a set of values.
  • Network Data Model- this model is different from relational model, as data relationship is represented  as records that are connected as links.a record is collection of attributes each having a data value and link represents association between two records.
  • Hierarchical Data Model- In this data models also the data is represented as records but relationship is represented as a tree rather than an arbitrary graph.in this model the records have 1:N parent child relationship.
  • Object Oriented Data Model.- this data model is based on the concept of objects and classes. here data and the operation that can be carried out on it are represented as an object. An object can be defined as any real world object having some characteristic and behaviors. A class is a collection of similar type of objects. The OO models offers following features.
  1. Object identity. to be cont'd...

Comments

Post a Comment

Popular posts from this blog

  AI in the Indian Classroom: A Catalyst for Transformative Education The burgeoning field of Artificial Intelligence holds immense promise for revolutionizing school education in India, offering innovative solutions to long-standing challenges of scale, diversity, and equitable access. Beyond the hype, AI's exciting use cases are poised to reshape the traditional classroom into a dynamic, personalized, and efficient learning environment, tailored to the unique needs of a diverse student population. One of the most impactful applications of AI is in personalized and adaptive learning. In a country with varying learning speeds and socio-economic backgrounds, AI-powered platforms can transcend the limitations of a one-size-fits-all approach. By analyzing a student's performance data, AI can identify specific learning gaps, strengths, and preferred learning styles. For instance, an AI tutor can create a customized curriculum, offering remedial modules to a student struggling with ...
Post a Comment
Read more

KVS PGT COMP SC PAPERS

KVS PGT CS PAPER 2014- CLICK HERE TO DOWNLOAD THIS IS TAKEN FROM SOME WHERE ON INTERNET AND ANS MARKED IN THIS PAPER ARE NOT CORRECT. THERE ARE MANY ANSWERS WHICK ARE MARKED WRONG. THE IDEA TO POST IT HERE IS TO GIVE A GLIMPSE OF PAPER TYPE TO PROSPECTIVE CANDIDATES.
Post a Comment
Read more

JDBC Connectivity and More!!

JDBC  defines a universal interface for accessing various relational databases. The main function of JDBC API( java database connectivity application programming interface) is to provide methods for developer to prepare and send SQL statements to database server and fetch the results in database independent manner. it involes the following steps- establish a DB connection. send SQL statement to the DB server. fetch the result from server and process as required. classes used in java for DB connectivity. the DriverManager class. the Connection class. the Statement class. the ResultSet class. Configuring MySql Connector for java connectivity. to connect your java program to MySql server- the first requirement is  to install MySql Connector/J driver. the driver may downloaded from http://dev.mysql.com/downloads. goto netbeans->tools->libraries and add the mysql connector/j  .jar you just downloaded using add jar folder button. to establi...
Post a Comment
Read more