Stuff

Database Design and ERD Creation

Chris Copenhaver

October 27,2015

Sam Haidar

DBM 380

Memo

To: Stakeholders

From: Chris Copenhaver

Date: October 27, 2015

Subject: In this week, we will talk about the sensible configuration, information definition and relationship between the tables of database.

Logical Design

An intelligent outline is a calculated and unique configuration. In Logical database, you have managed just characterizing the sorts of data that you require. Essentially it is procedure to characterize coherent connection in the middle of elements and characteristics. In our database, we have three table; Art, Artist and Art area and all tables have 4-4 field.

Art table

It contains five fields; Size, Genre, Value, Date Created, ART_ID (a primary key).

Artist Table

It contains five fields: ARTIST_ID (primary key), ART_ID (Foreign key), Name, Address, Telephone, and Amount of Art.

Art Location Table

It contains size fields; ID (PK), Section, Location, Start Date, End Date, and ART_ID (FK).

Data Types for Table

Information sorts, Key determination the most vital things to do in database outlining. In our, There are three tables. Information sorts, key meaning of every table are given beneath:

Art Table

Field | Data Type | Key | Constraint |

ART_ID | INT | PK | Auto Increment, Not Null |

Size | INT | | Not Null |

Genre | VARCHAR(40) | | Not Null |

Value | VARCHAR(40) | | Not Null |

Date Created | Date/Time | | Not Null |

Artist Table

Field | Data Type | Key | Constraint |

ARTIST_ID | INT | PK | Auto Increment ,Not null |

ART_ID | INT | FK | Not null |

Name | VARCHAR(50) | | Not null |

Address | VARCHAR(250) | | Null |

Telephone | VARCHAR(12) | | Not null |

Amount of Art | INT | | Not null |

Art Location Table

Field | Data Type | Key | Constraint |

ID | INT | PK | Auto Increment, Not null |

Section | VARCHAR(50) | | not null |

Location | VARCHAR(100) | | not null |

Start Date |...