Relational Database Schema

-

 

Introduction for relational database schema

A relational schema is a plan used in database design to represent the data to be entered into the database and describe how that is structured in tables. It describes how those table relate with each tables.


 

Comments

Post a Comment

Popular posts from this blog

Identification of Attributes

-
Image
  Introduction of Attributes An attributes is a property or characteristic of an entity. An entity may contain any number of attributes . One of the attribute considered as the primary Key. Also we can explain like this, Attributes is entity are represented by means of their properties called attributes. In an entity - relational model, are represented in an elliptical shape.   All attributes have values. There are several types of attribute in ER-modal. Types of Attributes Ø Simple Attributes ­: Simple attributes are atomic value, which cannot be                         further. For an example, a student phone number is an atomic value of 10 digits. Ø Composite Attributes : An attributes that can be split into components is a composite attributes. Ø Single-valued   Attributes : The attribute which takes up only a single value for each entity instance is a single-valued attributes. For an example, the age of a student. Ø Multi-valued Attributes : The attributes w
Read more

ER Diagram with Assumptions and Explanation

-
Image
  Introduction for ER diagram ER Diagram means Entity Relationship Diagram in DBMS. Entity Relationship model describes the structure of the database from the help of this diagram. ER diagram uses for data modelling and relational database. There are some components of an entity relationship diagram such as entities, attributes, relationships and connecting lines. The Entity-Relationship Diagram of the academic institution system shows all the  instrument of the database table and the relational between students, faculties, registrations, staff, teachers and etc. In this diagram,    There are 4 entities, they are  Institude, Department DepatHead   Staff
Read more

About selected scenario

-
   We have selected the 2nd scenario as our case study topic. The sample scenario what we selected is, Scenario 2 : An academic institute in your town wants to set up a database to record details about its staff, and the departments they belong to. They intend to record the following information. For each member of staff, their staff identity number, name, job title, and salary, for each department, its name and address, and for each member of st aff, all departments that they belong to. It is required that every member of staff belongs to at least one department. For each department, there is a head of department. It is required that each department has exactly one head of department. Develop a sy stem to manage the day - to - day business of this institute .            Above scenario guide us to develop a system to manage the day-to-day business of the academic institute.
Read more