A step by step process of redesigning Aras' database model with MySQLWorkbench. *Note: This is a project completed on behalf of Aras Corparation as part of a final project for my Database Management class. Dummy data was used through out the process
A database is an organized collection of data, generally stored and accessed electronically from a computer system. Aras’ customers are very big companies like Microsoft and GE Aviation. Each of these large corporations have slightly smaller companies within them. The purpose of this project is to find a way to roll up all of these individual companies that belong to a bigger company under that Enterprise company's accounts.
one of the first steps in a database design is identifying the business rules. A business rule defines or constrains some aspect of business and always resolves to either true or false. You base a business rule on the way the organization perceives and uses its data, which you determine from the manner in which the organization functions or conducts its business. See below an example of some business rules followed in this project
An ER diagram shows the relationship among entity sets. An entity set is a group of similar entities and these entities can have attributes. An entity in a dbms is a table or attribute of a table. Relationships could be one to one, one to many, or many to many. ER diagrams are used to sketch out the design of a database.
Relational schema refers to the meta-data that describes the structure of data within a certain domain. It is the blueprint of a database that outlines the way its structure organizes data into tables.
Below are sample queries for creating a table using mysqlworkbench. *Note: Tables can also be automatically uploaded on mysqlworkbench
Refrences: https://www.oreilly.com/library/view/database-design-for/0201752840/ch11s02.html