Microsoft Access Database

timer Asked: Nov 21st, 2016

Question description

I've finished most of it. Just need a few steps completed.

BUS375-002 Management Information Systems – Fall 2016 Project II – Using a RDBMS The objective of this group project is to gain an experience of developing and managing data resources in the business world. For this project each group will be using relational database softwares such as MS-Access (available in our lab) or others. Each group is responsible for giving a class demo about their project using power point presentation, producing a written report (max 5 pages hardcopy/printout) and a softcopy on a (CD). Without presentation the group/individual will not get any marks for this project. As discussed in the class, each group must have to register a company/organization with the instructor before starting the project. Once registered, the group will have to develop a thorough understanding of that company’s information management. Specifically your group will have to do the following: 1) Develop and assign a suitable name for the selected company’s database. 2) Divide the company’s data into at least five tables (each table will have its own attributes) and give meaningful table name for them. 3) Draw an Entity Relationship Diagram (ER Diagram) for the database with at least 1 or more (one – one relationship) and 1 or more (one – many relationship). 4) Enter fifteen reasonable data in each table (including proper primary keys if needed) by creating forms. Avoid redundant data within the database. 5) Develop three queries and two parametric queries for your database. 6) For determining the company’s overall (ex: employee cost or other) , print a report showing all data (such as employers’ first name, last name, pay, education, salary, date of joining and add the total salary of all the employees). 7) Give three additional recommendation tables as to how the database can be developed further in future. General Information: For all groups, the written project is due on 29th Nov, 2016 during class time. Groups must register their company and the presentation time with the instructor on or before 8th Nov, 2016. Each class demo will be for a period of about 15 minutes (10min- demo + 5min- question/answer) using power point software.

Tutor Answer

(Top Tutor) Studypool Tutor
School: Carnegie Mellon University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors