SQL Concepts and Database Designs Kendra Robinson CIS/505 November 20, 2016 Professor Osama Morad SQL Concepts and Database Design Top of Form Bottom of Form Data Dictionary The data dictionary provides structure and governance over the data stored in the database. The table below will provide the specifics related to the key attributes of the database. Table Name Attribute Name Contents Description Data Type Format Range PK or FK Employee EmpNumber Employee ID number NUMBER(8) ####### NA PK

EmpFirstName Employee first name VARCHAR(20) Xxxxxxx NA

EmpLastName Employee last name VARCHAR(20) Xxxxxxx NA

CommisionRate Employee commission rate NUMBER(6,2)

.

NA

YrlySalary Employee yearly salary NUMBER(6,2)

NA

DepartmentID Employee department ID VARCHAR(20) XXXX NA

...