logo

Database Design and ERD Creation Assignment

5 Pages464 Words285 Views
   

Added on  2019-10-18

Database Design and ERD Creation Assignment

   Added on 2019-10-18

ShareRelated Documents
Running Head: DATABASE DESIGN AND ERD CREATION1Database Design and ERD CreationDJ LemakDBM 380June 27, 2016Craig Rose
Database Design and ERD Creation Assignment_1
Running Head: DATABASE DESIGN AND ERD CREATION2MemorandumTo: Whom It May ConcernFrom: DJ LemakDate: June 27, 2016Subject: Database Design and ERD CreationIntroductionThe Washington Contemporary Art Museum has new database system. All the entities and attributes of this database system are discussed in this paper along with the selection of primary keys, foreign keys and other constraints related to this database. In a museum where art work is displayed which is related to an artist who made it and the location of art work is related to the art. Entities and AttributesFollowing are the details of entities and attributes along with appropriate data type for each attribute and for its category. Integer data type is chosen for amount and telephone number attributes. Character data type is chosen for size and section of museum attributes because they are represented by single character. While String data type is chosen for those text which is of more than one character. Date data type is used for date attributes like date created, start data andend date etc. in database.EntitiesAttributesData TypesArt WorkValueIntegerSizeSmallCharacterMediumCharacter
Database Design and ERD Creation Assignment_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design in Oracle for Pet Net Online Library
|30
|4417
|90

Database of Business Rules Entities and Attributes
|20
|2546
|433

Term Project ERD
|7
|684
|295

Database System: Entities, Attributes, Relationships, and Normalization
|19
|1425
|294

Entity Relation Diagram for High Frequency Investments
|13
|1703
|57

Entity Relationship Diagram in Library Management System
|25
|2195
|76