The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 3 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
Hello, could you please help me with this project.
I attached all the requirements about the project in the file.
you can choose  ( Project 2 or Project3 )
Â
 Project 2
Â
Due Date: 29-Dec-2016
Â
Â
Â
Â
Introduction to DatabaseIT-244Database ProjectDue Date: 22-Dec-2016I.Instructions:1.In this file, you will find a list of database project ideas. You must choose one of them to designand implement.2.You can work on this project as a group (maximum 3 students) or individually. You have to sendthe names of group members to you your instructor by the end of week 7.3.This project worth 10 marks, will be distributed as following:a.Design the database, following an ER model.(2 marks)b.Normalize the tables ( each table should be in 3NF at least)(2 marks)c.Use MySQL or any other database to create the normalized tables.(2 marks)d.Populate your tables with 5 rows at least.(2 marks)e.Execute the sample requested queries.(2 marks)4.Each student has to submit one report about his/her project via the Blackboard contains thefollowing:a.ER Diagram.b.All schemas before and after normalization.c.All SQL statements of :i.creating tablesii.inserting data in tablesiii.queries.d.Screenshots from MySQL (or any other software you use) of all the tables after populationand queries results.II.Project Ideas:Project 1LSBU Outward Bound
Attachments:
-----------