Posts

Showing posts with the label What is Database Schema
  ❖Communication practices: Principle 1 Listen: •Try to focus on the speaker‘s words, rather than formulating your response to those words. •Ask for clarification if something is unclear, but avoid constant interruptions. •Never become contentious in your words or actions (e.g., rolling your eyes or shaking your head) as a person is talking. Principle 2 Prepare before you communicate: •Spend the time to understand the problem before you meet with others. If necessary, perform some research to understand business domain. •If you have responsibility for conducting a meeting, prepare an agenda in advance of the meeting. Principle 3 someone should facilitate the activity: •Every communication meeting should have a leader (a facilitator) 1)To keep the conversation moving in a productive direction, 2)To mediate any conflict that does occur, and 3)To ensure that other principles are followed. Principle 4 Face-to-face communication is best: •It usually works better when some other represen...

What is Database Schema

Image
Database Schema Database Schema:-The description of data in terms of data model of called as database schema. Which is specified unique database design and it does not expect to change frequently. A Database schema is the structure of database which represent physical view a logical view and entire database. It define how the data is arranged and how the relations among them are associated. .Types of Schema  1. Physical schema 2. Logical schema 3. View Schema  1.Physical schema :-Physical schema is also known internal schema the design of the database at a physical level is called as Physical schema . How the data is stored in storage is explained at this level   2. Logical schema:- The design of database at logical level is called as logical. The level gives a tabular structure of data    3. View Schema:- It is also known as external schema. The design of database at view level is called as view schema. This generally refer user and database system interac...