Answered step by step
Verified Expert Solution
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 entityrelationship 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 superclasssubclass hierarchy for any of these problems, but may choose to do so if you wish. A website has a URL, and a title. A website is associated with company and a company is associated with to many websites. A company has a unique name, a business genre such as financial, commercial, nonprofit 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 to many websites for their company. A website is created by 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 and only website, the user name is only unique for that specific website. A website can have 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started