Thursday, March 5, 2015

Database Research Projects

For carrying out database research projects, you can design an entity relationship diagram after identifying the entities, attributes of the entities and relationships of the system, convert it to a relational model (table schemas) and normalize the tables and finally design the diagram including split tables, if any from normalization. You can fill up tables with values and make sure there are no conflicts between primary and foreign keys. For this to set up, you can use MySQL or SQL Server. You can query the system with proper queries and check to see if the system is giving the correct results. So, this will be the back-end of the database system. You can create a user friendly interface at the front-end and connect it with the back-end. For designing the interface you can use PhP/javascript, C# or ASP.net. This system can be any enterprise you choose from daily life like a hospital, bank, travel agency, fast food restaurant, any sport or music band that you would like to design as a database system.

In my next blog, I will talk about database theses that are useful to work on.

No comments:

Post a Comment