Report The assignment is a complete package of database design and development. It is the combination of logical and physical design both. WE worked in group on this assignment. First we completed the logical design and after that on the basis of logical design, physical design is created. Challenges The most challenging task in the assignment was creating the ER diagram,. we all group members studied the case study carefully and made the ER diagram. It was really challenging and interesting too. Limitations The assignment has no limitations. It is the complete package which is teaching to design a database from scratch. Benefits The assignment is teaching number of things as below- -Use of SQL Queries -Use of reverse engineering feature in MYSQL -Use of normalization which is the base of every DBMS