[Solved] ERD Tool

Question 1:  Using a suitable ERD tool develop ERD for a gym database. You may choose entity types e.g. gym members, employees, programs available, program opted, location, health emergency. You need to identify relevant attributes for each entity type. Identify composite attributes, multivalued attributes, and week entities. Apply appropriate constraints (e.g. primary key, foreign key, not null, unique). Identify relationships among various entities.  Some conditions are specified below: a. The employees can be staff or trainers. The employee type field is used to distinguish between the two which take the values “S” and “T” for staff and trainer respectively.  b. Each member can opt for one or more programs. c. The gym offers several programs. A program might not be chosen by any member of the gym. d. The gym’s management wishes to track the payment details of members (amount, mode of payment, and date of payment). Suggest how can they track. e. While exercising in the gym if any member gets injured then gym management should be able to arrange a medical emergency facility.  Question 2: Draw an “Extended Entity Relationship Diagram” for the following problem: A company posts job openings online. Job seekers must apply for these jobs online as well. The company will process the applications and call eligible job seekers for an interview. Upon successful completion of the interview, the job seeker may be hired, and the corresponding job opening will be deleted from the company’s Website. Job seekers have an ID, name, work history, and qualifications. A job posting can be either for a part-time or full-time position. Part-time positions have a total number of weekly hours and an hourly rate. Full-time positions have a monthly salary. Both types of job listings have details about the position and the company.  Note: In question 2, Identify appropriate entities, attributes, relationships and apply extended entity relationship concepts such as specialization (total /partial), generalization, supertype sub type whichever you feel useful/applicable as per the question. For more information on ERD Tool  read this: https://en.wikipedia.org/w/index.php?search=+ERD+Tool+&title=Special%3ASearch&go=Go&ns0=1

 

Don't use plagiarized sources. Get Your Custom Essay on
[Solved] ERD Tool
Get a 15% discount on this Paper
Order Essay

 

So much stress and so little time? We’ve got you covered. Get your paper proofread, edited or written from scratch within the tight deadline.

Quality Guaranteed

With us, you are either satisfied 100% or you get your money back-No monkey business

Check Prices
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know that being a student these days is hard. Because of this, our prices are some of the lowest on the market.

Instead, we offer perks, discounts, and free services to enhance your experience.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
s
Get personalized services with My Paper Support
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Social Work and Human Services
Great Work!
Customer 452587, August 31st, 2021
Technology
My paper was sent back after my due date time
Customer 452901, November 12th, 2022
Human Resources Management (HRM)
Thank you so much.
Customer 452701, June 28th, 2023
Psychology
Thanks so very much. The paper is well-researched and adequately referenced. You have been of great help during the pandemic!
Customer 452467, January 31st, 2021
Human Resources Management (HRM)
Dynamic!!
Customer 452701, October 17th, 2023
Nursing
Great work. thank you again!
Customer 452707, August 7th, 2022
Nursing
Always a wonderful experience!
Customer 452453, February 23rd, 2023
English 101
I'm glad i came to you guys
Customer 452519, May 11th, 2021
Human Resources Management (HRM)
Excellent Thank you.
Customer 452813, January 11th, 2025
Technology
Great job on the paper!
Customer 452885, December 14th, 2022
History
Thanks for your help and support as always!
Customer 452909, May 18th, 2024
Nursing
Great! Thanks again!
Customer 452707, July 4th, 2022
Enjoy affordable prices and lifetime discounts
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Order Now Order in Chat

Ensure originality, uphold integrity, and achieve excellence. Get FREE Turnitin AI Reports with every order.