Applied Database Systems Project - ER Design

You have selected your topic. Now it's time to write specifications and design the database.

The topic is about the battlefield sites and the antiquities/monuments associated with them.

Requirement -

1. Creating a diagram

2. Writing the list of data requirements and assumptions

a. Requirement Analysis. Make a list of the data requirements. An example requirement would be: 1) for each book, the catalog contains its ISBN number, title, author, purchase price, sales price, and the year the book was published; 2) professors can manage and work on multiple projects.

b. Analysis and Conceptual Design. Analyze your project and come up with an ER diagrams. Make sure that you don't forget:

1. Cardinalities.

2. Constraints (if any) that apply over and above what you can show in the diagram. State, using full-English sentences (in bullets), all of your assumptions for the entities and relations in your design that are covered in part (a) and not shown in the ER diagram.

For example: We assume: 1. A person can have one social security number 2. A person may hold multiple jobs. etc..

Attachment:- Assignment Files.rar