DETAILS Using the relational tables (next pages) create (1) a data dictionary and (2) a list of indexes. The data dictionary should provide details for each field: table name, field name, data type, nulls allowed, primary key, unique, foreign key (listing table name and field name of primary key), and any comments/assumptions about the field. You MUST comment on every field. Use the template XLSX file provided. Note that the file has a worksheet for the tables and a worksheet for the indexes. Be specific with data types (e.g., VARCHAR2(50)) and select the most restrictive data type possible. Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a precision of 5 and a scale of 2 . FORMAT TABLE LISTING Your list of tables should be in the following format. IDEX LISTIIG In addition to the data dictionary, you must create a list of indexes. For each index, provide a name, the table and fields the index is for, and why the index is being created (example below). Assume an index will automatically be created for each primary key, but you should list these indexes as well. ASSUMPTONS: State all assumptions made. Please put your name in your document. Instructions for submitting the assignment on D2L are at the beginning of this document. RELATIONAL TABLES - BCU_Account (AccountNumber, AccountType, Balance, DependentEmployeenumber. DependentFirst_Name, DependentLast_Name, Employee_Number) Primary Key: AccountNumber, AccountType - Foreign Key: DependentEmployeeNumber, DependentFirstName, DependentLastName References Dependent - Foreign Key: EmployeeNumber References Employee - Building (BuildingNumber, BuildingName, Planumbner) - Primary Key: BuildingNumber - Foreign Key: PlantNumber References Plant - Dependent (EmployeeNumber, DependentFirstName, DependentLastName, Relationship, BirthDate, Gender) Primary Key: EmployeeNumber, DependentFirstName, DependentLastName - Foreign Key: EmployeeNumber References Employee - Employee (EmployeeNumber, FirstName, LastName, StreetLine1, StreetLine2, City, State, Postal, - Primary Key: EmployeeNumber - Foreign Key: PlantNumber References Plant Foreign Key: SupervisorNumber References Employee - Hobby (HobbyName, Activity) - Primary Key: HobbyName - Job (EmployeeNumber, ProjectNumber) - Primary Key: E- Employen Number, ProjectNumber - Foreign Key: EmployeeNumber References Employee - Foreign Key: ProjectNumber References Project - Manager (ManagerNumber, ManagerStartDate) - Primary Key: ManagerNumber - Foreign Key: ManagerNumber References Employee - Participation (HobbyName, DependentEmployeeNumber, DependentFirstName, DependentLastName, AnnualCost, HoursPerW) Primary Key: HobbyName, DependentEmployeeNumber, DependentFirstName, DependentLastName - Foreign Key: HobbyName References Hobby Foreign Key: DependentEmployeeNumber, DependentName References Dependent - P Plant (PlantNumber, PlantName, Budget, Mnager_numenber) Primary Key: PlantNumber Foreign Key: ManagerNumber References Manager - Primary Key: ProjectNumber Foreign Key: PlantNumber References Plant DETAILS Using the relational tables (next pages) create (1) a data dictionary and (2) a list of indexes. The data dictionary should provide details for each field: table name, field name, data type, nulls allowed, primary key, unique, foreign key (listing table name and field name of primary key), and any comments/assumptions about the field. You MUST comment on every field. Use the template XLSX file provided. Note that the file has a worksheet for the tables and a worksheet for the indexes. Be specific with data types (e.g., VARCHAR2(50)) and select the most restrictive data type possible. Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a precision of 5 and a scale of 2 . FORMAT TABLE LISTING Your list of tables should be in the following format. IDEX LISTIIG In addition to the data dictionary, you must create a list of indexes. For each index, provide a name, the table and fields the index is for, and why the index is being created (example below). Assume an index will automatically be created for each primary key, but you should list these indexes as well. ASSUMPTONS: State all assumptions made. Please put your name in your document. Instructions for submitting the assignment on D2L are at the beginning of this document. RELATIONAL TABLES - BCU_Account (AccountNumber, AccountType, Balance, DependentEmployeenumber. DependentFirst_Name, DependentLast_Name, Employee_Number) Primary Key: AccountNumber, AccountType - Foreign Key: DependentEmployeeNumber, DependentFirstName, DependentLastName References Dependent - Foreign Key: EmployeeNumber References Employee - Building (BuildingNumber, BuildingName, Planumbner) - Primary Key: BuildingNumber - Foreign Key: PlantNumber References Plant - Dependent (EmployeeNumber, DependentFirstName, DependentLastName, Relationship, BirthDate, Gender) Primary Key: EmployeeNumber, DependentFirstName, DependentLastName - Foreign Key: EmployeeNumber References Employee - Employee (EmployeeNumber, FirstName, LastName, StreetLine1, StreetLine2, City, State, Postal, - Primary Key: EmployeeNumber - Foreign Key: PlantNumber References Plant Foreign Key: SupervisorNumber References Employee - Hobby (HobbyName, Activity) - Primary Key: HobbyName - Job (EmployeeNumber, ProjectNumber) - Primary Key: E- Employen Number, ProjectNumber - Foreign Key: EmployeeNumber References Employee - Foreign Key: ProjectNumber References Project - Manager (ManagerNumber, ManagerStartDate) - Primary Key: ManagerNumber - Foreign Key: ManagerNumber References Employee - Participation (HobbyName, DependentEmployeeNumber, DependentFirstName, DependentLastName, AnnualCost, HoursPerW) Primary Key: HobbyName, DependentEmployeeNumber, DependentFirstName, DependentLastName - Foreign Key: HobbyName References Hobby Foreign Key: DependentEmployeeNumber, DependentName References Dependent - P Plant (PlantNumber, PlantName, Budget, Mnager_numenber) Primary Key: PlantNumber Foreign Key: ManagerNumber References Manager - Primary Key: ProjectNumber Foreign Key: PlantNumber References Plant