. Design an Entity-Relationship-Model of your specific subject
- Define entities and relationsships with reasonable attributes
2. Define primary key (PK) attributes for every entity
3. Dissolve all 1:1, 1:N, M:N relations by defining foreign keys (FK) and extra tables repectively.
4. Normalize all tables:
- Analyze and find multivalued or repeated attributes to bring the relations into the 1. Normal Form (1NF)
- Analyze and identify functional and transitive dependencies between attributes of all tables to bring the tables into the 2. and 3. Normal Form (2NF + 3NF)
5. Define data types for all attributes
6. Create all necessary tables in a MySQL database (can be done with tools like phpmyadmin)
7. Fill in some meaningful data
8. Show by example with SQL statements, that some useful issues can be answered by the system
Please write an additional report, where all stages and decisions of the development are explained and reasoned..
19 pekerja bebas membida secara purata €152 untuk pekerjaan ini
Hello , I would like to make your project. I am experienced SQL and Java developer and my goals is responsibility , clear and professional coding and attention for details.
I am a full stack web developer specialized in php framework codeignitor, develop websites in minimum time with clean code , follow object oriented approach .