LIS 670 In-Class Exercise

1. LIS 670In-Class Exercise Creating a Preliminary Database Design Using the Entity-Relationship Model

2. We have been asked to design: A Digital Library of Art for the Tott Kahn Vasse School of Art at the University of Finn-Gurpeyne Tours

3. A Digital Library of Artfor the Tott Kahn Vasse School of Art at the University of Finn-Gurpeyne Tours Drawing Survey of Global Art Ceramics Life Drawing Glass Later Art of Japan Design: Typography Classes Offered Painting Art of Tribal Africa Sculpture Photography Exhibit Design & Gallery Mgmt Intaglio Printmaking Woven Structures

4. We have been asked to design a Digital Library of Art for the Tott Kahn Vasse School of Art at the University of Finn-Gurpeyne Tours Artist-Entity Z-Entity __________________ __________________ __________________ __________________ __________________ Artist_ID Z_ID __________________ __________________ __________________ __________________ __________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ Image_LCN Name Artist Art Attributes Image_Entity Y-Entity Q-Entity Attributes __________________ __________________ __________________ __________________ __________________ Y_ID __________________ __________________ __________________ __________________ __________________ Q_ID Image Attributes

5. You have been asked to design a Digital Library of Music Recordings for the Skri Chee Music Department at the University of Fienne Sound _________-Entity _________-Entity __________________ __________________ __________________ __________________ __________________ ___________ID Z_ID __________________ __________________ __________________ __________________ __________________ Image_LCN ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ Recording_Entity _________-Entity _________-Entity Attributes Y_ID __________________ __________________ __________________ __________________ __________________ __________________ __________________ __________________ __________________ __________________ Q_ID

6. You have been asked to design a Digital Library of Crime Data for the Elbonian Bureau of Investigation _________-Entity _________-Entity __________________ __________________ __________________ __________________ __________________ ___________ID Z_ID __________________ __________________ __________________ __________________ __________________ Image_LCN ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ Crime_Entity _________-Entity _________-Entity Attributes Y_ID __________________ __________________ __________________ __________________ __________________ __________________ __________________ __________________ __________________ __________________ Q_ID

7. __________Entity ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ Image_LCN ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ ____________________ Image_LCN __________Entity Attributes Attributes