Updating Tables And Sql Identificationsouthern New Hampshire

Updating Tables and SQL IdentificationSouthern New Hampshire UniversityDAD-220-J8560 Intro to Struct Database Env 24EW3 01:43:11 GMT -05:00DAD 220 Module Two Activity TemplateReplace the bracketed text in this template with your answers and any supporting screenshots. Then submit it for the Module Two table and SQL identification activity. You’ll need to download this template, save it as a unique file, and then submit it for grading. Rename this document to include your last name and remove these instructions before submitting.Using the tables and SQL statements from the prompt for Module Two Activity, answer the following questions. Replace the bracketed text with your answers and any supporting screenshots.1. How many records are shown in the Employee table?The Employee table has 5 records.2. How many attributes are there in the Branches table?The Branches table has 2 attributes.3. Which attribute could be a primary key for the Employee table?The Employee_ID4. How many decimal places (maximum) can be stored in an employee’s salary field?A maximum of two decimal places5. How many decimal places (maximum) can a Department_ID have?Zero decimals6. What three rules do tables obey?They are normalized, there are no duplicate column names within the same