Use the data model designed in Week 2 ( I have attached this). This data model will be reviewed and taken from the conceptual model to logical and physical model status.
Make sure you define the following:
1. Select database management system (Oracle, SQL Server, MYSQL, etc) and identify the data types and sizes for all attributes.
2. Make sure all relationships have been addressed and corrected.
3. Review data model to make sure data model is in at least 3rd normal form (as defined by the normalization process).
WebsitesOracle Data Types provides hardware and software availabilities. https://www.oracle.com/index.htmlSQL Server data types provides SQL server information. https://www.microsoft.com/en-us/sql-server/sql-ser…MySQL data types provides information about database management. https://www.mysql.com/Videos:#action=share#action=share