Closed

Management of Information System Term Project

Deliverables:

1- Project description. This is an initial but reasonably well-thought out, one page description of your project. Provide enough details about the scope of your project, A rough idea of scope is that an acceptable project is likely to yield at least 15 or so relation in the final design.

2- Entity-Relationship Model. Provide a complete design for your project using Entity-Relationship Model.

3-Relational Design. Provide a complete relational design for your project. Include designs for your user view as well.

4-Database implementation. Implement your database design with sample data and a Web accessible interface.

The above deliverables will be in 2 phases. A document and a presentation are expected in each phase.

Phase 1: Database requirements and conceptual design

1- Describe the application and expected output as explained above (in deliverable no. 1) explain why a database is needed for this application and the benefits and drawbacks of having a database system.

2- Provide a brief description of the system including the required functions, basic entities and their attributes as well as the relationship linking the various entities.

3-Conceptual Database design: draw an Enhanced Entity-Relationship diagram for the application. Be sure to indicate the assumptions and constraints of the EER diagram.

4- Suggest queries for all user levels.

Note: The EER diagram can be easily drawn in Microsoft Word but hand-drawn graphs are acceptable at this stage

Phase 2: Physical Design and implementation

1- Properly refine your phase 1 according to feedback and suggestions.

2- Map the EER diagram onto relational tables.

3-Implement and populate the tables in Microsoft Access.

4- Decide on the queries you want to have

5- Write the queries in SQL & build an interface for them ( the queries shouldn't be repetitive & must support the selected report)

6-Normalize the tables, discuss the possible problems of the design.

7-Develop the screens, forms, and reports.

8-Provide sample runs on the implemented functions.

The final report should incorporate changes suggested in phased 1 (e.g. adding a certain query, correcting problems in the EER design, etc) It should integrate all the pieces you've done in both phases. You are expected to provide scenarios about how the Senior Managers would use the database to generate reports, be sure to submit the SQL files together with report (MSWord) file.

The Project:

A Pizza Parlor Database:

Design a database system for a pizza parlor. You may for instance track information about employees, pizzas available, calorie content etc. Show how this database will be used by at least two different types of users, For example: employees and customers as well as Managers. Employees may be able to check the inventory while the customers may be able to view pizzas available at the parlor or place online orders.

Skills: Database Administration, Microsoft, Microsoft Access, Research Writing, SQL

See more: pizza parlor management information system, explain term database information system project, write presentation report online, why use graphs, why are graphs used, web designs forms, types of data graphs, sql inventory system, sample of requirements document, project management scenarios, out of scope requirements, online on how to write a report, levels system, it project managers required, implementation of graphs, how to write a requirements document example, how to draw web design, how are graphs used, hand drawn web designs, g web online user interface, graphs problems, graphs online, graphs design online, forms of graphs, example of inventory database

About the Employer:
( 0 reviews ) Egypt

Project ID: #4020149

12 freelancers are bidding on average $715 for this job

imranhossain

Hello sir, Greetings!!!Right person is here according to your requirement. I'm constantly providing great, highly informative, analysis where necessary, great and quality papers, essays, reports, case study, dissert More

$1200 USD in 18 days
(62 Reviews)
5.7
chinnapd007

********************************************.. YOUR SEARCH ENDS HERE .. ********************************************** GET IT DONE RIGHT THE FIRST TIME! Hello, @@@@@@ Please Check PMB for More Details @@@@@@, More

$100 USD in 2 days
(57 Reviews)
5.2
samin59

You think about quality, we deliver it. Please check PM.

$1200 USD in 15 days
(28 Reviews)
5.0
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$600 USD in 30 days
(1 Review)
4.0
feninsoftech

Hi, I have 7 years experience in ASP.NET, C# and SQL Server. Reports can be designed in SSRS

$800 USD in 45 days
(3 Reviews)
3.7
sadeque

Lets start....

$200 USD in 7 days
(5 Reviews)
3.3
Thesmarttechies

We can do this ... please check your PM

$590 USD in 7 days
(2 Reviews)
0.6
geogeorge2

Please let me know if you are interested.

$2000 USD in 10 days
(0 Reviews)
0.0
jianbensong

I have done a similar project when I was taking the Database design and implemenntation class some years ago. After I graduated I have been working in the database design and development field for many years. You don't More

$250 USD in 5 days
(0 Reviews)
0.0
boyet0911

Experience programmer/developer here. Kindly check you pmb for my details. Thanks.

$1000 USD in 30 days
(0 Reviews)
1.5
onlyLekha

I am good at -Database Design -Coding which be readable and understandable for you -Documentation of each phase of above -Making Presentation Overall I will provide complete package which will definitely benefi More

$235 USD in 10 days
(0 Reviews)
0.0
jhenidahinfotech

Dear Sir, I am expert in writing academic writing and doing this kind of jobs for the last 6 years. Thanks

$250 USD in 21 days
(0 Reviews)
2.4
techwelfare

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.

$250 USD in 12 days
(0 Reviews)
0.0