• • • • • • • • • • • • • o o • • ➢ ➢ ➢ • • • • • NYSE Daily Price Schema NYSE_daily_prices_A Name Data Type Unit date date stock_symbol string stock_price_open float stock_price_close float...

Part A
Contents
Part A    1
Database Development    2
Design    2
Modelling techniques    2
Naming Conventions    2
Creation of entities and Attributes    2
Procedure 1: Entity Relationship Diagrams    2
Procedure 2: Relational Database Management Systems    2
Platforms    3
Accessibility features    3
References    3
Database Development
MySQL is the database management system selected for the storing the data of Skillage IT. This DBMS shall facilitate computing and standalone utilities for the company.
Design
MySQL incorporates the data into tables in a structured form instead of storing like a storeroom. The physical structure organizes the database structures into physical files boosted for speed. The logical structure includes tables, views, columns and rows offering flexibility to data management. The tables are linked together using primary and foreign keys. Rules are defined by the developers for allowing data access which are enforced by the database so that the application for Skillage I. T. does not have inconsistency, duplicity or missing data.
Modelling techniques
Data modelling techniques represent the data objects and relationships among them through visual representation. These techniques help in analyzing data requirements for business processes....