Relational Databases with MS Project: Access - Computer Science homework help

timer Asked: Aug 16th, 2016

Question description

This assignment is a tfour-part project building off the first week.  Imagine there were four assignments.  Question 1 is for Week 1.  Question 2 is for Week 2.  Question 3 is for Week 3.  


You MUST submit the answers as labeled Week 1, Week 2, and Week 3.


Question 1 (Week 1):  You are about to create an application to manage your CDs/DVDs collection.  The application to keep track of the inventory (in/out), who borrowed what and when it is due back (no money transactions please., the system should be able to produce at least 3 reports such as inventory list, items due most active user and most borrowed item.


What are the steps you are going to take to complete the development process?  Include a detail requirement (5 pages max) with suggest design and ER diagram.  Use MS Word for the diagram.  You MUST inclue the strcture of the tables in the Database not the data and there needs to be first and last names


Question 2 (Week 2):  Create the database you defined in Question 1 (Week 1).  Use simple SQL inserts to append records to each table you created.  There needs to be 3 records per table.  Save these SQL statements in a text file and submit it with the database.


Question 3 (Week 3):  Create the following:  An appropriate form for each table with add/edit/delete functionality.  Forms MUST include 1.)  frmBorrower(add, edit, delete, list borrower), 2. frmMedia (add, edit, delete, list media) 3. frmQuickSearchMedia (lookup media, show status of the media, such as in house, out and who checked it out) 4. frmQuickSearchBrower.  



Do NOT send me a automaticac reply without having read the assignment.  I will pass you over.  Send me a IM stating you have read the assignment. 


Do this correctly and there will be 8 more weeks of assignments coming your way.

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