Question: A database is needed for maintaining the websites related to courses taught at a university. The characteristics of a Web page include a unique ID,

 A database is needed for maintaining the websites related to courses

A database is needed for maintaining the websites related to courses taught at a university. The characteristics of a Web page include a unique ID, a title, its URL, and the number of times that the web page has been accessed. A course Web page has an associated base page and a base Web page serves as the base of all of the Web pages associated with the course. A Web page can be accessed through the link on another page. A Web page can display many graphics and a graphic can be displayed by many Web pages. The characteristics of a graphic include a unique ID, the name of the graphic, the format of the image, such as 'gif, jpg' or 'bmp, and the directory in which the graphic image is located. A Web page can provide ftp links to several courseware files and a courseware file must be linked to by some Web page(s). The characteristics of courseware include a unique ID, a description of the course material, the directory in which the file material is located and a category describing the type of course material, such as 'P' for publication, 'N' for notes. Design an ER diagram for the above. Specify key attributes of each entity type and structural constraints on each relationship type. Specify any additional assumptions. A database is needed for maintaining the websites related to courses taught at a university. The characteristics of a Web page include a unique ID, a title, its URL, and the number of times that the web page has been accessed. A course Web page has an associated base page and a base Web page serves as the base of all of the Web pages associated with the course. A Web page can be accessed through the link on another page. A Web page can display many graphics and a graphic can be displayed by many Web pages. The characteristics of a graphic include a unique ID, the name of the graphic, the format of the image, such as 'gif, jpg' or 'bmp, and the directory in which the graphic image is located. A Web page can provide ftp links to several courseware files and a courseware file must be linked to by some Web page(s). The characteristics of courseware include a unique ID, a description of the course material, the directory in which the file material is located and a category describing the type of course material, such as 'P' for publication, 'N' for notes. Design an ER diagram for the above. Specify key attributes of each entity type and structural constraints on each relationship type. Specify any additional assumptions

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!