huynhhoangkha/database-spring2019

database-spring2019

Diagrams are drawn with draw.io and saved in Google Drive at links bellow

• ERD: Draw.IO ERD File
• Mapping: Draw.IO Mapping File

Phase 1: software specification

• File: softwareSpecifications.txt
  • Kha: I, II, VI, VII
  • Dat: III, IV, V, VIII

Phase 2: create a list of entity and relationship

• File: entitiesList.txt
  • Phong: read the specification and make a list of entities/relationship

   Note: Please ask/exchange as soon as you get something confusing.
  

Note: use the following syntax:

I. Entities:
	1. Entity name
		- Entity attribute 1
		- Entity attribute 2 (derived)
		- Entity composite attribute
			+ Child attribute 1 (key)
			+ Child attribute 2
				-- Child of child 1
				-- Child of child 2 
				-- Child of child 3 (optional)
		- Entity attribute 3 (multivalue)
	...
II. Relationships:
	1. Relationship name
		- Relationship attribute 1
		- Relationship attribute 2 (derived)
		- Relationship composite attribute
			+ Child attribute 1 (key)
			+ Child attribute 2
				-- Child of child 1
				-- Child of child 2 
				-- Child of child 3 (optional)
		- Relationship attribute 3 (multivalue)
		- Entity 1:
			+ Mandatory (yes/no)
			+ cardinality: (1 or N...)
		- Entity 2:
			+ Mandatory (yes/no)
			+ cardinality: (1 or M...)
	...

Progress

• Person entity OK
• Project entity OK
• Infrastructure management OK
• Community activity OK

Phase 3: draw the ERD

• File at (Kha, Dat):

  Draw.IO ERD File Done!

Phase 4: mapping

• File at (Dat):

  Draw.IO Mapping File

Phase 5: creating database using SQL statements

• File: *.sql
  Kha + Phong: Generate data and SQL code for inserting into tables
  Dat: Write SQL code for creating tables and create indexes