Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Nu Faces Model Agency would like to store details on the models they manage. There are various types of models the company would like to

image text in transcribed
Nu Faces Model Agency would like to store details on the models they manage. There are various types of models the company would like to track. Advertising models are placed in commercials hence they would like to store their experience level while they would like to track the personal website handle and ranking of the international models. Sometimes an international model may do advertisements. Each model has a base fee. Some models go by an alias. All models have a model\#, birth name, dob, gender, height and weight and their calculated BMI. The agents at the agency have been arranged into clusters and each cluster is led by a senior agent who allocates the portfolios of the models to the cluster. Only the current head of the cluster is required to be stored. Each model is managed by a cluster of agents. International models may be booked for different shows and hence the company would like to know the details by storing the title of the show, city and date of the show. The shows are organized by a Designer whose details needs to be stored such as the brand name, their net worth, contact personnel, contact number and head office address (street, city, town, country and zip code). Whenever an international model worked on a show, the designer will provide critique from their panelists of how the model did on the runway. Hence a model may receive more than one critique from the designer for the same show. The critique has a sequential number for each number of panelist for that show and has the rating for the model' s performance in the show, position he/she started, critique and number of appearances in the show. The company would also like to know which particular agent from the cluster was responsible for booking an International model for a show, since agents work on commission. Each agent has a TRN, name (including first, middle and last), phone numbers and percentage commission. Required 1. Construct an ER diagram from the description above. Include required attributes to make the data storage meaningful. [40 marks]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Medical Image Databases

Authors: Stephen T.C. Wong

1st Edition

1461375398, 978-1461375395

More Books

Students also viewed these Databases questions