Question: Convert the following textual description to an entity - relationship diagram in UML notation. Please spend time differentiating between entities, attributes, relationships and values of

Convert the following textual description to an entity-relationship diagram in UML notation. Please spend time differentiating between entities, attributes, relationships and values of attributes. If you are identifying a strong entity - make sure you identify a primary key for it. Remember, weak entities do not have a primary key. You are not required to use superclass/subclass hierarchy for any of these problems, but may choose to do so if you wish. 1.A website has a URL, a title, and the creator of the website. A website is associated with 1 company and a company is associated with 1 to many websites. A company has a unique name, a business genre (such as financial, commercial, non-profit etc.), and an address that is composed of a street number, street name, town, state, zip code. Each website has a collection of valid users. For each user, we track their user name, the password, their full name and their country of origin. A user is associated with 1 and only 1 website, the user name is only unique for that specific website. A website can have 0 to many users that have logged in or are logged in. When a user logs into a website we track the date and time of the login.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!