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 on paper. Please spend time differentiating between entities, attributes, relationships and

Convert the following textual description to an entity-relationship diagram in UML notation on paper. 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, 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.

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

Database And Transaction Processing

Authors: Philip M. Lewis, Arthur Bernstein, Michael Kifer

1st Edition

0201708728, 978-0201708721

More Books

Students also viewed these Databases questions