Too design, develop and implement a database for The Aquatics Swim Club. The overall design will include choosing the tables, fields, keys, and relationships, and making sure that all tables are in either 3rd or 4th normal form.  You will also develop policies for security, backup and recovery, and shared update.   More detail plz see the attachment. I am willing to pay $60.00 for this project.

 

CIT 170Database ProjectAfter reading through this entire document, please watch the video on ProjectDesign Hints. The video has additional information to assist you with your designphase.You are to design, develop and implement a database for The Aquatics Swim Clubbased on the concepts you have learned in CIT 170.All documents must be producedon a computer.You should carefully read this entire document prior to beginning workon this project.This project is worth a total of 100 points.The specific breakdown foreach phase is noted below.Your overall design will include choosing the tables, fields, keys, and relationships, andmaking sure that all tables are in either 3rdor 4thnormal form.You will also developpolicies for security, backup and recovery, and shared update. The specifics for eachphase are as follows:Design - 40 points1. Define all entities, attributes, data types, and whether null values will beaccepted.2. Specify any candidate keys for each table.3. Select the primary key for each entity.4. Describe all foreign keys and their related tables.5. Define all relationships, including type (one-to-one, one-to-many, or many-to-many).6. Describe any domain constraints (legal values/check constraints).7. Produce an Entity-Relationship diagram, which will visually describe thedatabase design.8. Produce the DBDL for each table.Turn in for the Design Phase:1. An Entity-Relationship diagram describing each table.This should looklike the ER diagrams in Chapter 6.2. DBDL describing each table.This should look like the DBDL examples inChapter 6.Your DBDL will show any candidate or alternate keys, primarykey(s), and foreign keys.3. A listing for each table which includes each of the following:a.Field namesb.Data typesc.Whether nulls will be acceptedd.Domain constraints (legal values/check constraints)e. Field size for character data typesPlease use a copy of the listing below to complete #3 for each individual table:Table Name:FieldNameNULLSAllowedDataTypeFieldSizeDomainconstraints1WorkfileContents.docx