Explain Database Schema and design a schema for Record of Students of any UNIVERSITY

Database Schema:- 

  •   A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how the relations among them are associated. It formulates all the constraints that are to be applied on the data.


  • A database schema defines its entities and the relationship among them. It contains a descriptive detail of the database, which can be depicted by means of schema diagrams. It’s the database designers who design the schema to help programmers understand the database and make it useful.

Design a schema for Record of Students of any UNIVERSITY


School (school_id, school_name)

Course(course_id, course_name, teacher_id)

Teacher(teacher_id, teacher_name, school_id)

Student(student_id, student_name, absent_days, tardy_days, school_id)

Assignment(assignment_id, assignment_name, assignment_date, category, score, course_id, student_id)


2nd example

School (school_id, school_name, course_id)

Course(course_id, course_name, teacher_id, student_id)

Teacher(teacher_id, teacher_name, student_id)

Student(student_id, student_name, grade, absent_days, tardy_days, assignment_id)

Assignment(assignment_id, assignment_name, assignment_date, category, score, course_id)


Data Instance: 

It is important that we distinguish these two terms individually. Database schema is the skeleton of database. It is designed when the database doesn't exist at all. Once the database is operational, it is very difficult to make any changes to it. A database schema does not contain any data or information.

A database instance is a state of operational database with data at any given time. It contains a snapshot of the database. Database instances tend to change with time. A DBMS ensures that its every instance (state) is in a valid state, by diligently following all the validations, constraints, and conditions that the database designers have imposed.






 ignore 
Same answer for these questions

  1. What is an example of a database schema?
  2. What is schema design?
  3. What is the difference between star schema and relational model?
  4. What happens if you don't have a database schema?
  5. student schema example?
  6. how to design a database schema?
  7. university database schema example?


keywords

explain database schema
what is database design about
what is database schema with example
what is schema in database
what is database vs schema
what is the purpose of schema in database
explain database schema with example
what is database schema in sql
what is database schema in mysql

Comments

Post a Comment

Popular posts from this blog

Quick Revision for Multimedia and Animation - Vikatu

Image
Unit 1     Multimedia is a type of medium that allows information to be easily transferred from one location to another . Multimedia is the presentation of  text ,  pictures ,  audio , and  video  with links and tools that allow the user to navigate, engage, create, and communicate using a computer. Multimedia refers to the computer-assisted integration of text, drawings, still and moving images(videos) graphics, audio, animation, and any other media in which any type of information can be expressed, stored, communicated, and processed digitally. Multimedia is being employed in a variety of disciplines, including  education ,  training , and  business . Applications of Multimedia   Multimedia indicates that, in addition to  text ,  graphics / drawings , and  photographs ,  computer information  can be represented using audio, video, and animation. Multimedia is used in: 1. Education In the subject of education, multimedia is becoming so popular. It is often used to pr
Read more

Java Quick revision

Image
UNIT I Parameters Java C++ First Release The Java language came into existence on 23rd May 1995. The C++ language first came into existence in October 1985. A stable form of Release The JDK 14 or Java SE was finally released on 17th March 2020. The C++ 17 was released back in December 2017. Founder James Gosling developed Java at Sun Microsystems. Bjarne Stroustrup developed C++ at Bell Labs back in 1979 in the form of an extension to the C language. Platform Dependency The Java bytecode can easily work on any given OS (operating system). It is very much platform-independent. The C++ language is platform-dependent. It means that we need to compile it for a different platform. Official Website The official website for Java is oracle.com/java The official website for C++ is isocpp.org Influenced By The C#, C++, Pascal, Ada 83, and many more languages have an influence on the Java language. Smalltalk, Simula, ML, C, ALGOL 68, Ada, and many more languages have an influence on the C++ langu
Read more

Quick revision for software engineering by vikatu

Image
UNIT I Software characteristics refer to the qualities or attributes that define the behavior, functionality, and performance of a software system. These characteristics help in evaluating, understanding, and designing software effectively. Here are some common software characteristics: Functionality : It refers to the extent to which the software performs its intended tasks. A software system should meet the specified requirements and provide the desired features to users. Reliability : This characteristic indicates the ability of the software to perform consistently and predictably under various conditions. Reliable software should be robust and resilient to errors and failures. Usability : Usability measures how easy it is for users to interact with the software. It involves aspects such as user interface design, intuitiveness, simplicity, and accessibility. Efficiency : Efficiency relates to the optimal use of system resources (such as CPU, memory, and disk space) to achieve desire
Read more