Create a new website using C# & ASP.Net in Visual Studio:

1. Create a web page to access a database and display the data from a table by providing an SQL statement. Create the page with these requirements:

    create label, textbox and button
    the textbox will capture the SQL statement
    the button will process the statement and display the results

2. Add necessary data access pages to your project.

3. Display the data in Gridview

A Video store (AVS) runs a standard video stores. Before a video can be put on the shelf, it must be cataloged and entered into the video database. Every customer must have a valid a AVS customer card to rent a video. Customers rent videos for three days at a time. Every time a customer rent video, the system must ensure that he/she does not have any overdue videos. If so, the overdue videos must be returned and an overdue fee paid before customer can rent more videos, Likewise, if the customer has returned overdue videos but not paid the overdue fee, the fee must be paid before new videos can be rented. Every morning, the store manager prints a report that lists overdue videos. If a video is two or more days overdue, the manager calls the customer to remind him/her to return the video. If a video is returned in damaged condition, the manager removes it from the database.

1. Create a State Machine Diagram the above information

2. Choose two different senerios from the above situation and make a sequence diagram for each

Assignment 1 - IN PDF FORMAT Using R and Rstudio

Pick a database from: data()

Then preview the first 10 rows.

Print the number of rows and columns

- Print the names of the variables

If you have row names, print them - work with the values for a field in your dataset. You can do it by dataset[[xx]] operator with xx can be the index of the field or the nae of the field.

Now use dataset[xx] to get a slice of datframe instead of vector, e.g. df = mtcars[c(‘mpg’, ‘disp’)] - With two scalar arguments (rows,columns), the [] operator can select elements in the dataframe. Try this.

- Subset your data using rules similar to the lectures. For example part of the data that has a characteristics AND/OR another one, etc.

- Write a function that does an operation, for example averaging a property, on your dataset.

- Write a function that works on rows and adds a column to the dataset with the results for each row.

- Using the iris database, explain the following line of code:

data(iris) aggregate(iris["Petal.Length"], by = iris["Species"], FUN=median)

## Species Petal.Length

## 1 setosa 1.50

## 2 versicolor 4.35

## 3 virginica 5.55

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?