Question: We would like to design a database to maintain information about the World-Wide Web. The following information needs to be captured: 1. Hosts on the

We would like to design a database to maintain information about the World-Wide Web. The following information needs to be captured:

1. Hosts on the web, which are characterized by their IP address, location, names and the server software running on them.

2. Associated with the hosts are directories . Each directory has a name (dname) which is unique on a given host. Thus a directory is essentially identified by the host machine on which it resides and its name (dname). We also need to store the last date of modification of the directory and the filenames under the directory. Directories can be classified as either root or non-root. While a root directory has no parent, non-root directories have a parent which is also a directory. Also, a non-root directory has associated with it access permissions.

3. We also store information about clients, which access a host machine. The client is characterized by an IP address, client name (cname) and each access to a host machine is associated with a timestamp.

Draw an ER model based on the above-mentioned scenario. If you need additional assumptions to complete your diagram, please state your assumptions here as well. In your diagram, please specify the key of entity types, the multiplicity of relationship types (one-to-many, many-to-many, etc.), and the constraints.

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!