ISM 530 & 521 Task 3
khairul30
ISM530_Task3.docxISM530 Assignment # 3
For a geographic information system develop a logical data warehouse design diagram, a physical data warehouse model diagram.
· Create the diagrams and give explanations of the diagrams.
· For examples of table diagrams, see this site: https://www.visual-paradigm.com/support/documents/vpuserguide/3563/3564/85378_conceptual,l.html and also google for logical vs physical diagrams. There are lots of examples.
· For information about GIS, use the web. A large GIS company is ESRI, and they have been in the business for decades. Here is some info: https://www.esri.com/en-us/what-is-gis/overview For a big GIS example, see this JHU site: https://coronavirus.jhu.edu/ For a natural resources example, look at this: https://mrdata.usgs.gov/ So many examples of GIS!
Use Lucidchart/MSVisio to create the diagrams
Max of 10 pages, include a title page and a ref page. Use the rubric as a guide for content.
Rubrics:
|
Elements |
Exceeds Competency |
|
Logical Data Warehouse Design Diagram
Required Elements: 1. Entity names 2. Attributes 3. Data type suggested |
Presents a clear, logical data warehouse diagram that shows what the data is in depth and includes links between data sources. Includes all required elements. However, it does not include information on implementation. The diagram is made digitally using appropriate software and graphic techniques. Additionally contains links to additional information that will enhance the readers understanding. |
|
Physical Data Warehouse Model Diagram
Required elements: 1. specification all tables and columns 2. foreign keys to identify relationships between tables 3. denormalization based on user requirements 4. physical considerations that cause it to be different from the logical model
|
Presents a clear, physical data warehouse diagram that shows how the model will be built in the database. It includes indepth, clear and accurate information on implementation including relationships and all required elements. The diagram is made digitally using appropriate software and graphic techniques. Additionally contains links to additional information that will enhance the readers understanding. |
Note:
If you are using any diagram, please make sure you reference it.
