Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Demystifying Databases A Hands On Guide For Database Management

Authors: Shiva Sukula

1st Edition

8170005345, 978-8170005346

Students also viewed these Databases questions

Question

an element of formality in the workplace between different levels;

Answered: 1 week ago