Create an E$-$R model for Case Study $37($attached to homework$).$ This should include any assumptions

you make and anything else that you think helps explain, clarify, and validate your model. You do not have to

complete the queries section. The queries section can be used to make decisions on how to structure your E$-$R

model. Case study $37$

Personalization in Data Mining

Problem Description

Personalized web pages are sites that present the user with only the news and advertisements of interest. Creating such websites is challenging because it is very difficult, in data mining, to scrutinize the news and advertisements by keyword and present personalized information to the user. Users' interests are generally obtained by asking questions about their preferences and by analyzing past browsing behaviors. The aim of this project is to build a database decision support system that allows classifying the news$/$advertisements on certain categories and then, depending on users' requests, presents the corresponding information. In fact, this system solves only part of the problem described above.

Database Design

We present the main entity types of this database. For each entity type, we provide some of the corresponding attributes. Use this information in order to: $($a$)$ Build an Enhanced E$-$R diagram;

$$araw theralatene

$1.$ Advertisement: The main attributes are name, description, category, targeted age group, targeted gender, etc.

$2.$ Category: The main attributes are name, description, etc.

$3.$ News: The main attributes are name, category, date, description, keywords, etc.

$4.$ User. The main attributes are identification number, login name, password, name, address, gender, age, profession, hobbies, personal preferences, etc.

$5.$ Website: The main attributes are address, category, description, keywords, etc.

Note that the database keeps track of user behavior: the number of times a user read the news of a particular category, the number of times a user visited a particular website, the number of times a user accessed advertisements of a particular category, etc.

Access Application Development

The following are some of the queries, forms, and reports one can create in order to increase the functionality of the database.