Data Base 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 is designed when the database doesn't exist at all.

Instructions in Creating the Artifact

This instructions are inetended to give you a better scope of what a good Data Base Schema could be like rather than a sole resource for the artifact of your project. You may need to tailor it and make several other changes to ensure it is a good fit for your use and project.

Title Each data base should contain a table name as it will be design in the application.
Attributes: Each table should contain the attributes and their type that will be used for the application (it is a good idea to depict the primary and secondary keys next to the attributes).
Association: Each table should be connected to tables through arrows depicting their one to one, one to many, or many to many associations.

Things to keep in mind

• Avoid duplication of datastored.
• Avoid unnecessary calls to the database.
• Keep your naming consistent.

Examples of Data Base Schemas

• Database Schema from CSE 110 Winter 2012
• Database Schema from CSE 110 Winter 2012
• Database Schema from CSE 110 Spring 2015
• NoSQL Database Schema from CSE 110 Winter 2017
• Database Schema from CSE 110 Fall 2020

Please refer to resources for some of the technolgies that could be used to develop a Data Base Schema.

---