An IT-consulting company has a large number of corporate clients. Corporate clients are registered by consultants....

  

Transcribed Image Text:

An IT-consulting company has a large number of corporate clients. Corporate clients are registered by consultants. Any client who is registered must have exactly one dedicated consultant (who is responsible for registration process). Each consultant may register any number of clients, including none. Once registered, a given client must be consulted by at least one consultant in a company. Similarly, every consultant must consult at least once. At a certain time of consulting, a (big) client may be consulted by multiple consultants at the same time. Also, a particular consultant may consult any number of clients at the same time (i.e., "group consulting"). Whenever a client is consulted by a consultant, the company wishes to record the consultation details which includes Date, Time, and Advice. Note that attributes of CONSULTANT include ConsultantID (the identifier) and Specialization (such as Database, Security, etc.). Attributes of CLIENT include ClientID (the identifier) and ClientName. Requirements: Draw a conceptual ER diagram (using Diagrams.net or similar tools) for the above situation. Your ER diagram should identify all the entities, relationships, and attributes described above. Indicate primary keys and the cardinality of each relationship. Go to Settings to activate Win An IT-consulting company has a large number of corporate clients. Corporate clients are registered by consultants. Any client who is registered must have exactly one dedicated consultant (who is responsible for registration process). Each consultant may register any number of clients, including none. Once registered, a given client must be consulted by at least one consultant in a company. Similarly, every consultant must consult at least once. At a certain time of consulting, a (big) client may be consulted by multiple consultants at the same time. Also, a particular consultant may consult any number of clients at the same time (i.e., "group consulting"). Whenever a client is consulted by a consultant, the company wishes to record the consultation details which includes Date, Time, and Advice. Note that attributes of CONSULTANT include ConsultantID (the identifier) and Specialization (such as Database, Security, etc.). Attributes of CLIENT include ClientID (the identifier) and ClientName. Requirements: Draw a conceptual ER diagram (using Diagrams.net or similar tools) for the above situation. Your ER diagram should identify all the entities, relationships, and attributes described above. Indicate primary keys and the cardinality of each relationship. Go to Settings to activate Win

Answer rating: 100% (QA)

Clients Clientin Entity R... View the full answer