Question: Each question is worth 1 0 points each. Convert the following textual description to an entity - relationship diagram in UML notation. Please spend time

Each question is worth 10 points each. 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.
A website has a unique URL, a title, a company it is associated with and the creator of the
website.
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.
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.
A website has a URL, and a title. 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. A company employs staff members. For each staff member
we track the unique staff id, their full name (first and last), and department. A staff member
creates 0 to many websites for their company. A website is created by 1 staff member. 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.
 Each question is worth 10 points each. Convert the following textual

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!