I need help please with this project. 

    After reading through this entire document, please watch the video on Project 
Design Hints. The video has additional information to assist you with your design
phase.
You are to design, develop and implement a database for The Aquatics Swim Club 
based on the concepts you have learned in CIT 170. All documents must be produced 
on a computer. You should carefully read this entire document prior to beginning work 
on this project. This project is worth a total of 100 points. The specific breakdown for 
each phase is noted below.
Your overall design will include choosing the tables, fields, keys, and relationships, and 
making sure that all tables are in either 3
rd
or 4
th
normal form. You will also develop 
policies for security, backup and recovery, and shared update. The specifics for each 
phase are as follows:

 

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 points1Define all entities, attributes, data types, and whether null values will beaccepted.2Specify any candidate keys for each table.3Select the primary key for each entity.4Describe all foreign keys and their related tables.5Define all relationships, including type (one-to-one, one-to-many, or many-to-many).6Describe any domain constraints (legal values/check constraints).7Produce an Entity-Relationship diagram, which will visually describe thedatabase design.8Produce the DBDL for each table.Turn in for the Design Phase:1An Entity-Relationship diagram describing each table.This should looklike the ER diagrams in Chapter 6.2DBDL 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.3A 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:FieldNameNULLSAllowedDataTypeFieldSizeDomainconstraints1qattachments_07ba4f6fe466df8cda048f628ad51b60957bb930.docx

Attachments:

• 1495154456-CIT170Project.docx