timer Asked: May 1st, 2020

Question Description


this question for specific tutor to do Database Managmnet.

correct Phase II work on Phase III ( use Smardraw )

Microsoft Access

Unformatted Attachment Preview

1.) Make all changes and/or corrections to Phase II as indicated, and include those parts that were indicated as incomplete or missing in Phase II. THIS ALSO INCLUDES making Phase I corrections that were still not correct in Phase II. ----------------------------------------------------------------------2.) Each team consists of 6 members. You were earlier to decide with 3 of you would perform the Oracle SQL (or MySQL) work and which 3 of you would perform MS Access work. Having decided these “sub-teams”: SQL Team and MS Access Team, you are to each create databases and inputting these with actual data in both MS Access and ORACLE SQL. Use these databases created to perform a multitude of Single-Table & Multiple Table queries of team’s selection. Provide printouts of all of the databases that you have created including data format specifications, and populated with actual data, and provide printouts of all queries that you have performed. Please see handouts of projects of previous years as well as those posted in Blackboard Learn. SQL Team is to provide printouts of CREATE TABLE, Select * from, DESCRIBE, etc. SUBSTANTIVE EQUAL AMOUNTS OF MS ACCESS & ORACLE SQL NEED TO BE COMPLETED FOR PHASE III (Look at previous year’s projects handed out & on Blackboard !) ----------------------------------------------------------------------3.) A detailed discussion of the applications of advanced database techniques to the database that your team selected. Phase II included that for Chapters 9 (Data Warehousing) & Chapter 13-Online (Distributed Databases). Expand this to also include that also for: the applications of Chapters 7 (Databases in Application), 10 (Big Data Technologies), 11 (Analytics and its Implications) and Chapter 12 (Data and Database Administration with Focus on Data Quality) to your team project. NOTE that NOT ALL of these topics may even be applicable to the database that your team selected!!! Hence part of this project is for your team to determine which of these techniques discussed in the course are applicable to your database selected. ----------------------------------------------------------------------4.) Provide a write-up of the "Summary and Conclusions" section of your term team project. ----------------------------------------------------------------------5.) Provide a TABLE OF THE DIVISION OF LABOR as to who did what parts of Phase III. That is, indicate who worked on which Normalization figures, EER diagram, and MS Access and ORACLE SQL computer work, etc. Each team needs to provide a TABLE OF THE DIVISION OF LABOR as to who did what parts of Phase III that illustrates an “Equitable Distribution of Labor”. ------------------------------------------------------------------------------ 1ST FORM OF NORMALIZATION 1NF CUSTOMER 1NF CUSTOMER 1NF CUSTOMER 2ND FORM OF NORMALIZATION 2NF CUSTOMER 2NF CUSTOMER 3RD FORM OF NORMALIZATION 3NF CUSTOMER 3NF CUSTOMER 3NF CUSTOMER ...
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Questions
Related Tags

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