QuestionQuestion

In this project you will develop a Access database and use PHP scripts to show that you can view, add, maintain, and delete data from it using simple Web forms.

Your Access database is based on an entity/relationship diagram (ERD) that is posted in the Content, Course Resources section. After creating your database you need to move if to the virtual environment (a.k.a. VDA). Since there is no FTP connection ability to the VDA to upload your Access database file you will need to e-mail it to yourself, or use Google Drive, Dropbox, or some similar approach to transfer your files.

Since there is an ODBC System Data Source Name (DSN) already set for you called "SDEVDemo" that is connected to an existing Access database file "cmis008f.mdb" in your c:\inetpub\wwwroot\PHP1 directory, you should use this name for your database and overwrite the existing file there.

Before doing this, check out the PHP demos described in the document "CMIS 485 Virtual Desktop Environment Access" first to see how the URLs are related to the PHP scripts by name and location. The instructor will give you the source code to these files to give you a head start on this project to develop your own PHP scripts to communicate with your own Access database.

Your database must be a Access 2003 version .mdb file so you will probably need to save your Access 2007 or later .accdb Access database into an earlier compatible format. Your database is to be based on the Reston Real Estate entity/relationship diagram (ERD) in the Content, Course resources section of the LEO classroom.

Your PHP script files must be set up to allow a user the ability to view existing data in your Access database and add, update, or delete any data they wish. Your scripts must accept the data specified by the user to generate the necessary SQL SELECT, INSERT, UPDATE, and DELETE statements. They must not simply excute SQL with hardcoded values.

The ERD used for Project 1 will also be used as the basis of the Project 2, Project 3, and Final Project database, except that these projects will use an Oracle database, if all goes well with Oracle in the VDA. If not, then the instructor may allow the use of your Access database. It isintended that you create and maintain your Oracle database in the VDA via SQL Developer. Nova is not available for this class via the VDA.

It is intended that you do the steps for this project in order. Note that Step 2 calls for the creation of a Student Web Page. This is simply an HTML Web page that contains links to the PHP scripts for the various steps of this project, along with necessary textual descriptions and graphics. All projects will have a Student Web Page like this.

Since the instructor does not have access to your VDAs, the deliverables are mostly screen snapshots of forms and data as your PHP scripts are executed in your VDA. For some steps other files are also required as noted. Please use WinZip or a similar utility to compress your files into a single .zip file for submission.

The Application

The Reston Real Estate Company (RRE Co.) has been in business about four months and has experienced an explosion in home sales to customers in the Reston, Virginia and nearby suburban area. RRE Co. sells new as well as previously-owned homes. The company sells both standard model and custom homes of various sizes and styles, and uses a variety of different builders for new homes. The homes have standard and optional features, which include, among other things, fireplaces, decks, finished recreation rooms, carpet colors, Jacuzzi bathtubs, extra large kitchens, in-law apartments, and security systems. Homes also have a variable number of bedrooms, bathrooms, garage sizes, and lot sizes.

In addition to keeping standard information on customer's names, current addresses, and phone numbers (home and business), RRE Co. is interested in targeting their market to certain clientele, so they keep information on customer's ages (via birth date), employers, professions, other interests, and who referred them. RRE Co. has a number of agents, each assigned to assist several customers with the sale of a home. Information on agents' addresses and phone numbers is important to track them down for big deals. The amount of sales that agents have made (number and dollar amount) is also important because this impacts their commission. The length of time agents have been with the company as well as their selling ability also determines their sales position (i.e., title) in the hierarchy. Agents at some of the higher levels are responsible for handling the contracts with home builders (involved in new home sales).

The builders' names, locations, phone numbers and points of contact are important. RRE Co. needs to determine periodically which home models are selling best and uses this information to negotiate contract modifications with builders of those models. RRE Co. also handles warranty work for the first three years for homes it sells, so for each home it sells, the company needs to keep track of the purchaser's name, what work needed to be done, what was done, who did the work, miscellaneous comments, and how much the repairs cost. This work is done by subcontractors of RRE Co.

The Assignment

Step 1: Develop an Access database based on the supplied ERD for the RRE application. You only need to build HOMES, SALES, AGENTS, and CUSTOMERS tables, based upon the HOME, SALE, AGENT, and CUSTOMER entities in the ERD, respectfully. Do not worry about creating foreign keys for these tables since you won't be creating the tables they would reference.

All tables should have a primary key, and foreign keys should be established as necessary for good referential integrity, except as noted above. You must specify which fields should be set to "Required", Initial Values, and Validation Rules and Validation Text as applicable. Your data types should be appropriate for the field data you are storing. Populate each table in your database with at least one record of data each.

After creating your Access database move the .mdb file for it to the proper location in your VDA. You may create different directories and subdirectories in your VDA area but make sure you change your URLs to access your PHP scripts correctly by their location.

Your deliverables for this step include:

screen snapshots submitted to the LEO Project #1 Assignment link of Design Views of your tables (only one Design View is required per table; you should show examples of setting of Validation Rules and Validation Text, Required fields, and initial values)
screen snapshots submitted to the LEO Project #1 Assignment link of Datasheet Views of your tables, showing the data you populated your tables with and the Relationships window showing all referential integrity.

Step 2: Develop an HTML "Student Web Page" in your student directory that contains links to the PHP scripts and HTML files for the remaining steps of this project. You may wish to call this page "Project1.html". You may arrange your PHP script file code however you wish but make sure that a user can easily navigate your Web site to perform all the necessary database functions.

Step 3: Develop a PHP script, initiated from your Student Web Page that allows the retrieval (i.e. SQL SELECTs) of data from your CUSTOMERS table in your Access database.
Your deliverables for this step include:
a screen snapshot of a PHP Web form showing all the customers in your Access database
a copy of your PHP script source code listing(s)

Step 4: Develop a PHP script, initiated from your Student Web Page that allows the addition (i.e. SQL INSERTs) of data to your CUSTOMERS table in your Access database on the lab's Web server.
Your deliverables for this step include:
screen snapshots of PHP Web forms showing how the user entered data to be added to your database followed by a screen snapshot showing all existing customers to prove that the INSERT worked correctly
a copy of your PHP script source code listing(s)

Step 5: Develop a PHP script, initiated from your Student Web Page that allows the updating (i.e. SQL UPDATEs) of data in your CUSTOMERS table in your Access database on the lab's Web server.
Your deliverables for this step include:
screen snapshots of PHP Web forms showing how an existing customer data first, then the Web form of the data to be updated, and finally a Web form showing the resulting customer data to prove that the UPDATE worked correctly
a copy of your PHP script source code listing(s)

Step 6 : Develop a PHP script, initiated from your Student Web Page that allows the deletion (i.e. SQL DELETEs) of data from your CUSTOMERS table in your Access database on the lab's Web server.
Your deliverables for this step include:
screen snapshots of PHP Web forms showing the existing customers first, the Web form allowing the user to delete a customer, and finally a Web form showing the remaining customers to prove that the DELETE worked correctly
a copy of your PHP script source code listing(s)

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

<html>
    <head>
       <meta charset="UTF-8">
       <title></title>
    </head>
    <body>
       <form action="insert.php" method="POST">
            
            <table border="1">
                <thead>
                   <tr>
                        <th>Name</th>
                        <th>Value</th>
                   </tr>
                </thead>
                <tbody>
                   <tr>
                        <td>Customer ID</td>
                        <td><input type="text" name="cid" value="" /></td>
                   </tr>
                   <tr>
                        <td>First Name</td>
                        <td><input type="text" name="fname" value="John" /></td>
                   </tr>
                   <tr>
                        <td>Middle Name</td>
                        <td><input type="text" name="mname" value="Jr" /></td>
                   </tr>
                   <tr>...
$68.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Web Development (HTML, XML, PHP, JavaScript, Adobe, Flash, etc.) Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats