Project part 2 | English homework help

 Part#2: DATA STRUCTURE To do: 1. Using the ERD (reduced from Part 1) provided below, create logical data structures for  all the entities and associative entities.  2. For each data structure, include a Data Structure Form that lists all of the assumptions  and business rules relating to the data structures. (Copy of this form and sample  completed form are provided below (next page).)  To submit: 1. Include updated ERD + description page 2. Insert the pages for the data structures. There will be one page for each data structure. 3. Submit your work on Canvas by the due date.  

 Part#2: DATA STRUCTURE To do: 1. Using the ERD (reduced from Part 1) provided below, create logical data structures for all the entities and associative entities. 2. For each data structure, include a Data Structure Form that lists all of the assumptions and business rules relating to the data structures. (Copy of this form and sample completed form are provided below (next page).) To submit: 1. Include updated ERD + description page 2. Insert the pages for the data structures. There will be one page for each data structure. 3. Submit your work on Canvas by the due date. ERD for Group Project Part 2 TRANSACTION PK Transaction_Number Transaction_date Transaction_Total_Cost FK1 Member_ID FK2 Employee_ID EMPLOYEE PK Employee_ID Employee_Name Employee_Address Employee_Phone Employee_Hire_Date Employee_Position Employee_Status MEMBERSHIP PK Membership_ID Membership_Type Membership_Fee Membership_Discount MEMBER PK Member_ID Member_Name Member_Address Member_Gender Member_DOB Member_Join_Date FK1 Membership_ID FITNESS_CLASS PK Reference_Number Start_Date DaysOfWeekHeld Time_Period FK1 Course_Number FK2 Employee_ID FITNESS_COURSE PK Course_Number Course_Name Course_Description Course_Category Course_Duration Course_Fee has has has has has INSTRUCTOR_COURSE PK,FK1 Employee_ID PK,FK2 Course_Number DateQualified Qualification_Type CLASS_ENROLLMENT PK,FK1 Member_ID PK,FK2 Reference_Number Enrollment_Date has has has has 2 Sample page and instructions to illustrate Data Structure Form (TABLE NAME entered in all capital letters) Example TABLE: EMPLOYEE Business Rules: (List all cardinality rules that apply to this table, rules for primary key selection, referential integrity rules, etc.) Examples: • Each Employee has a unique ID. • Employee can be instructor for many courses, but a course is taught by only one Employee. • Only one phone number will be kept for each Employee. • Each Employee must have a name and a hire date. Data Structure: Example: EMPLOYEE(Employee_ID, Employee_Name, Employee_Address, Employee_Phone, Employee_Hire_Date, Employee_Position, Employee_Status) Underline primary key! Attribute Description: For each field identified in the data structure, complete the information in the table below. (Example ) Attribute Name Attribute Data Type Attribute Required? PK or FK FK Reference Table Employee_ID INTEGER Y PK Employee_Name VARCHAR(30) Y Employee_Address VARCHAR(25) Employee_Phone CHAR(12) Employee_Hire_Date CHAR(10) Y Employee_Position VARCHAR(25) Employee_Status CHAR(3) 

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 15% with the discount code GRADUATE