USING MICROSOFT ACCESS

ABC Exterminator serves customers in Queens. The technician travels to a customer’s home to exterminate pests, such as termites, ants and rats. The technician inspects the home, and then decides which chemical to use. The customers are charged only for the chemical used.

ABC has three technicians. Each technician covers 2 ZIP code areas. Technician’s zip code areas do not overlap with the zip code areas of other technicians. The company serves only 6 Zip code areas in Queens. The company sends out bills once a month at end of month.

1. Create_ a database for the Company. Name the database Quiz5--(Your Last_Name)

2. Create five tables as follows:

Customer: CustomerID (text, Primary Key), CustomerName (text), Address (text), ZipCode (text)

Chemical: ChemicalID (text, Primary Key), UnitPrice (Currency)  

Technician: TechnicianID (text, primary key), TechnicianName (text), SSN (text)

AreaCoveredByTechnician: Zipcode(text, Primary Key), TechnicianID (text). ( Note this table shows which area is covered by which technician)

Orders: CustomerID, ChemicalID, Quantity, OrderDate (date),OrderID (Text, Primary Key)

Instruction: Use Microsoft Visio to draw a use case diagram and a sequence diagram for the following business requirements.

Online Recruiting System (website)

1) The Online Interview System: The search committee usually selects 3 to 5 candidates for a Skype interview. When the search committee starts a Skype interview, they connect their web browsers to an interview module developed by the company’s IT team (we call this type of software as home-developed software). The interview module then connects to Skype. At the same time, the candidate (interviewee) also connects their web browser to Skype. Now the search committee and the candidate can see and talk with each other using their web browsers. Please note the data flow from the committee to the candidate must go through the interview module and Skype.

The interview lasts 40 minutes. During the interview, the interview module is recording a video. After the interview session is closed, the interview module saves the video into the HR database and then calls the AI module to translate the video a Microsoft Word document. After the video is fully translated to a Word document, the interview module saves the Word file into the HR database.

Consider the DataSource class in below code. Explain how inheritance is intended to be used with this class. Does this represent a good use of inheritance? Explain your answer

// Base class for game configuration

public abstract class DataSource {

    private Graph map;

    private HashMap <String,Room> rooms;

    private ArrayList <Entity> entities;

    private Player player;

    protected HashMap < String, List<String[]> > tables;

    // constructor

    public DataSource() {

    }

    // Connect to the data source. Override if source is a database

    public void connect() {

    };

    // Load the configuration tables required to build the game world

    public abstract void load();

    // Build the game world

    public final void build() {

      // code omitted

    }

// Disconnect from the data source. Override if source is a database

    public void disconnect() {

    };

    // Get a the layout of the game world

    public Graph getMap() {

       return map;

    }

    // Get room details. The HashMap key is the room label.

    public Map <String,Room> getRooms() {

        return rooms;

    }

    // Get player details

    public Player getPlayer() {

        return player;

    }

    // Get entity (bats, bird, monsters, wumpus) locations

    public List <Entity> getEntities() {

        return entities;

    }  

}

E-commerce Question

Study the scenario and complete the question(s) that follow:

Tshepiso Florists is a small flower business located in the Glen Austin neighbourhood. There are two
main types of clients that patronise Tshepiso Florists – gardening enthusiasts and people who need to
send flowers to their loved ones on special occasions.
Tshepiso is starting a gardening class online and she would like to send a notification via email to a
particular group of clients.
Create a database of at least 10 clients for Tshepiso Florists. Design an interface with which to send
the email notification to the appropriate group of clients. In the email, state the start date of the
gardening class and also offer a gift to the first 10 people who sign up for the class.

Question
Before designing for the client in the scenario above, use your device (laptop, computer or
phone) to look for a minimum of 4 cookies that are currently stored by sites that you have visited.
Take pictures of these cookies and attach them for submission as part of your answer to this
question.
Securely design a registration form, login form, landing page (of your choice) and database for
Tshepiso. Include a notification of the existence of cookies as well as a privacy notice.

You are a database designer and data analyst working for the hypothetical employer, Park University. The University over the last few years has provided faculty and staff needed technology to support various job functions but is having some trouble tracking such technology to ensure the program is cost-effective.   In other words, the University Controls Department is having difficulty locating inventories and associated invoicing information. With the lack of this important information, the University Controls department has a very difficult time locating and tracking released technology which has the intended purpose of being an asset to assigned employees and departments.

The University Controls department has a Technology Asset Management System currently designed and implemented using Microsoft Access; however, the Chief Information Officer (CIO) of Park University needs some ideas of possible reasons the current Technology Asset Management System designed in Microsoft Access is not currently tracking technology assets as intended.

In a memo style response to the Chief Information Officer (CIO), share-based on your knowledge learned about databases using experience and research, some possible and or hypothetical reasons why the existing database, in this case, is not working as intended?

Evaluating Source

One of the responsibilities often associated with management is the gathering of career-specific information on resources or professional development. Familiarity with professional sources shows you have interest in your field and invest time to stay current with developments and debates in your industry. Sources for the IT field.

For this assignment, you will identify credible sources related to your field. You will identify the sources using accurate APA format. Then, for each source, you will write two complete paragraphs that

1. Summarize the source;
2. Comment on the source’s benefits and currency.

For your sources, you should include at least one of each of the three following sources:

1. An academic or professional source from the Keiser e-library database. Avoid single articles, too. Try to identify a database or a journal relevant to your field.
2. A professional news in your field or a respected commercial site like The New York Times, The Wall Street Journal. An online magazine such as Forbes or Fortune might be appropriate, depending on your field.
3. An organizational site such as .org, .edu, and .gov site. Examples could include American Medical Association, the National Criminal Justice Association, the American Dairymen's Association, and so forth.

When should you use non-parametric tests of statistical significance? When is it inappropriate to use non-parametric statistical tests? Describe what is meant by the phrase: "Power of a a statistical test". Are non-parametric statistical procedures as powerful as parametric statistical procedures?

bash-3.2$ git init
Initialized empty Git repository in /Users/terry/Documents/Udel/teaching/275/275-Spring2018/gitPlay/.git/
bash-3.2$ git add *.txt
bash-3.2$ git commit -m "all"
[master (root-commit) f7a22b3] all
4 files changed, 27 insertions(+)
create mode 100644 dog.txt
create mode 100644 gitquiz.txt
create mode 100644 spam.txt
create mode 100644 spam2.txt
$ <edit spam.txt>
bash-3.2$ git add spam.txt
bash-3.2$ git commit -m "mod"
[master 8885fb1] mod
1 file changed, 2 insertions(+)
bash-3.2$ git branch feature
bash-3.2$ git checkout feature
Switched to branch 'feature'
bash-3.2$ cat >> spam2.txt
a new feature
bash-3.2$ git status
On branch feature
Changes not staged for commit:
(use "git add <file>..." to update what will be committed)
(use "git checkout -- <file>..." to discard changes in working directory)

   modified: spam2.txt

no changes added to commit (use "git add" and/or "git commit -a")
bash-3.2$ git commit -m "new feature to spam2"
On branch feature
Changes not staged for commit:
   modified: spam2.txt

no changes added to commit
bash-3.2$ git add spam2.txt
bash-3.2$ git commit -m "new feature to spam2"
[feature 3fbd9c3] new feature to spam2
1 file changed, 1 insertion(+)
bash-3.2$ git log --graph --all --simplify-by-decoration
* commit 3fbd9c356a36619a540920f8402a03f50d64f106 (HEAD -> feature)
| Author: Terry Harvey <[email protected]>
| Date: Mon Mar 19 10:25:30 2018 -0400
|
| new feature to spam2
|
* commit 8885fb16b61c8aeaf806bbbf3e8995f13f8f47e9 (master)
| Author: Terry Harvey <[email protected]>
| Date: Mon Mar 19 09:55:01 2018 -0400
|
| mod
|
* commit f7a22b3a9ebbd4dbc98ac9ac355b51022c6f2216
Author: Terry Harvey <[email protected]>
Date: Mon Mar 19 09:54:02 2018 -0400
  
all
bash-3.2$ cat spam2.txt
hooray for spam
second line
third line.
a feature
a new feature
bash-3.2$ git checkout master
Switched to branch 'master'
bash-3.2$ cat spam2.txt
hooray for spam
second line
third line.
a feature
bash-3.2$ ls
dog.txt       gitquiz.txt   spam.txt   spam2.txt
bash-3.2$ git rm spam2.txt
rm 'spam2.txt'
bash-3.2$ git commit -m "removed spam2.txt"
[master 4ee3d92] removed spam2.txt
1 file changed, 4 deletions(-)
delete mode 100644 spam2.txt
bash-3.2$ git checkout feature
Switched to branch 'feature'
bash-3.2$ ls

1. WHAT PRINTS HERE? Be sure you understand!

bash-3.2$ git checkout master
Switched to branch 'master'
bash-3.2$ ls

2. WHAT PRINTS HERE? Be sure you understand!

bash-3.2$ git tree //this is my alias for the log command above - put in your .gitconfig!
* commit 4ee3d92d15daa195bcdc89ccdc70b35d02981811 (HEAD -> master)
| Author: Terry Harvey <[email protected]>
| Date: Mon Mar 19 10:29:17 2018 -0400
|
| removed spam2.txt
|   
| * commit 3fbd9c356a36619a540920f8402a03f50d64f106 (feature)
|/ Author: Terry Harvey <[email protected]>
| Date: Mon Mar 19 10:25:30 2018 -0400
|   
| new feature to spam2
|
* commit f7a22b3a9ebbd4dbc98ac9ac355b51022c6f2216
Author: Terry Harvey <[email protected]>
Date: Mon Mar 19 09:54:02 2018 -0400
  
all

bash-3.2$ git checkout feature
Switched to branch 'feature'
bash-3.2$ git branch
* feature
master
bash-3.2$

3. What is HEAD?

4. What is master?

5. In this example, what is feature?

6. How would you take changes from a branch and apply them to master?

7. How would you remove a branch you no longer need?

bash-3.2$ git init
Initialized empty Git repository in /Users/terry/Documents/Udel/teaching/275/275-Spring2018/gitPlay/.git/
bash-3.2$ git add *.txt
bash-3.2$ git commit -m "all"
[master (root-commit) f7a22b3] all
4 files changed, 27 insertions(+)
create mode 100644 dog.txt
create mode 100644 gitquiz.txt
create mode 100644 spam.txt
create mode 100644 spam2.txt
$ <edit spam.txt>
bash-3.2$ git add spam.txt
bash-3.2$ git commit -m "mod"
[master 8885fb1] mod
1 file changed, 2 insertions(+)
bash-3.2$ git branch feature
bash-3.2$ git checkout feature
Switched to branch 'feature'
bash-3.2$ cat >> spam2.txt
a new feature
bash-3.2$ git status
On branch feature
Changes not staged for commit:
(use "git add <file>..." to update what will be committed)
(use "git checkout -- <file>..." to discard changes in working directory)

   modified: spam2.txt

no changes added to commit (use "git add" and/or "git commit -a")
bash-3.2$ git commit -m "new feature to spam2"
On branch feature
Changes not staged for commit:
   modified: spam2.txt

no changes added to commit
bash-3.2$ git add spam2.txt
bash-3.2$ git commit -m "new feature to spam2"
[feature 3fbd9c3] new feature to spam2
1 file changed, 1 insertion(+)
bash-3.2$ git log --graph --all --simplify-by-decoration
* commit 3fbd9c356a36619a540920f8402a03f50d64f106 (HEAD -> feature)
| Author: Terry Harvey <[email protected]>
| Date: Mon Mar 19 10:25:30 2018 -0400
|
| new feature to spam2
|
* commit 8885fb16b61c8aeaf806bbbf3e8995f13f8f47e9 (master)
| Author: Terry Harvey <[email protected]>
| Date: Mon Mar 19 09:55:01 2018 -0400
|
| mod
|
* commit f7a22b3a9ebbd4dbc98ac9ac355b51022c6f2216
Author: Terry Harvey <[email protected]>
Date: Mon Mar 19 09:54:02 2018 -0400
  
all
bash-3.2$ cat spam2.txt
hooray for spam
second line
third line.
a feature
a new feature
bash-3.2$ git checkout master
Switched to branch 'master'
bash-3.2$ cat spam2.txt
hooray for spam
second line
third line.
a feature
bash-3.2$ ls
dog.txt       gitquiz.txt   spam.txt   spam2.txt
bash-3.2$ git rm spam2.txt
rm 'spam2.txt'
bash-3.2$ git commit -m "removed spam2.txt"
[master 4ee3d92] removed spam2.txt
1 file changed, 4 deletions(-)
delete mode 100644 spam2.txt
bash-3.2$ git checkout feature
Switched to branch 'feature'
bash-3.2$ ls

1. WHAT PRINTS HERE? Be sure you understand!

bash-3.2$ git checkout master
Switched to branch 'master'
bash-3.2$ ls

2. WHAT PRINTS HERE? Be sure you understand!

bash-3.2$ git tree //this is my alias for the log command above - put in your .gitconfig!
* commit 4ee3d92d15daa195bcdc89ccdc70b35d02981811 (HEAD -> master)
| Author: Terry Harvey <[email protected]>
| Date: Mon Mar 19 10:29:17 2018 -0400
|
| removed spam2.txt
|   
| * commit 3fbd9c356a36619a540920f8402a03f50d64f106 (feature)
|/ Author: Terry Harvey <[email protected]>
| Date: Mon Mar 19 10:25:30 2018 -0400
|   
| new feature to spam2
|
* commit f7a22b3a9ebbd4dbc98ac9ac355b51022c6f2216
Author: Terry Harvey <[email protected]>
Date: Mon Mar 19 09:54:02 2018 -0400
  
all

bash-3.2$ git checkout feature
Switched to branch 'feature'
bash-3.2$ git branch
* feature
master
bash-3.2$

3. What is HEAD?

4. What is master?

5. In this example, what is feature?

6. How would you take changes from a branch and apply them to master?

7. How would you remove a branch you no longer need?