...MGS 8020 Business Intelligence Assignment 3 Please use the SQL (in MS Word) to answer the following questions. You may use subquery but all questions need to be completed in ONE SQL. You need to use the following tables (STUDENT and GPA) to answer Q1 – Q4. [pic] 1. What is the output if you have the following SQL? (10 points) Select * from STUDENT; Uncondition SQL that lists all the students from the student table with the respective columns. Select * from Student$ 2. Please find the average GPA for each student who lives in the following locations: (40 points) | Atlanta, GA | United States | | New Orleans, LA |United States | | Seoul | Korea | is the CITY in Korea Wasn’t sure which way the question was asking for the average GPA so I did both. Average by the city SELECT Student$.City, AVG(GPA$.GPA) as 'City GPA' FROM GPA$ INNER JOIN Student$ ON GPA$.Student_ID = Student$.Student_ID WHERE Student$.City IN ('Atlanta','New Orleans','Seoul') group by student$.city Average for the student, who lives in those cities SELECT student$.Student_Name, AVG(GPA$.GPA) FROM GPA$ INNER JOIN Student$ ON GPA$.Student_ID = Student$.Student_ID WHERE Student$.City IN ('Atlanta','New Orleans','Seoul') group by student$.Student_Name 3. Please find the student (Student...
Words: 438 - Pages: 2
...© 2009 Oracle Corporation – Proprietary and Confidential 1 Using TCA PL/SQL APIs Day,Friday, Date, 2004 time p.m. ET March 3, 2009 9:00 EST Teleconference Access: North America: xxxx Teleconference Access: International: xxxx North America: Password: Advisor +1-877-664-9143 International: +1-706-634 – 8961 Conference ID: 82200160 Upcoming Receivables Community Live Webcasts: March 6, 2009 - How to Use Receipts Application Programming Interfaces (APIs) to Create and Apply Receipts March 24, 2009 - Overview of Bills Receivable All Upcoming Advisor Webcasts are listed in Note 398884.1, Oracle Advisor Webcast Schedule. Do you have any requests for future Receivables Advisor Webcast Events? Please email your suggestions to ARNEWS_US@oracle.com, subject: Topics of Interest. © 2009 Oracle Corporation – Proprietary and Confidential 2 Agenda • Presentation and Demo – approximately 45 minutes • Q&A Session – approximately 15 minutes • • Please hold all questions to the end of the session. To ask a question, move your cursor to the top of the screen and select the ‘bubble’ icon next to the moderator’s name. A dialog box will open. Enter your question and select “Send.” • • During the Q&A session your question will be read and an answer will follow. © 2009 Oracle Corporation – Proprietary and Confidential 3 ATTENTION – AUDIO INFORMATION If you encounter any audio issues, please call InterCall (Audio Conferencing) and mute your phone. North...
Words: 3795 - Pages: 16
...queries. This application also uses advanced mechanism of using UDF (User Data File) which is used to protect the health care dataset. Responsibilities: Moved all personal health care data from database to HDFS for further processing. Developed the Sqoop scripts in order to make the interaction between Hive and MySQL Database Wrote MapReduce code for DE-Identifying data. Loaded the processed results into Hive tables. Generated test cases using MRunit. Best-Buy – Rehosting of Web Intelligence project The purpose of the project is to store terabytes of log information generated by the ecommerce website and extract meaning information out of it. The solution is based on the open source Big Data s/w Hadoop .The data will be stored in Hadoop file system and processed using PIG scripts. Which intern includes getting the raw html data from the websites, Process the html to obtain product and pricing information, Extract various reports out of the product pricing information and Export the information for further processing. This project is mainly for the re platforming of the current existing system which is running on Web Harvest a third party JAR and in MySQL DB to a new cloud solution technology called Hadoop which can able to process large date sets (i.e. Tera bytes and Peta bytes of data) in order to meet the client requirements with the...
Words: 500 - Pages: 2
...Parfait Payroll System Highly Customizable Payroll System This payroll system have the ff feature : * web-based payroll ( cloud ready ) * free mysql database * runs on Linux,Windows and Mac * WAN / LAN / Single Connection ready * Designed for Philippine Settings * Unlimited number of employees * Unlimited number of users * Multi Division / Department / Branch / Cost Centers ready * Multi-bank support * User maintainable updates on SSS, PhilHealth, Pagibig and Tax tables * Loan file maintenance, Unlimited Loan Type, automatic deduction with loan status monitoring * Unlimited Other Income Type * Batch Upload of Attendance, Loans, Deductions and Other Income via MS Excel * Leave Monitoring, Leave conversion available * Bonus,Mid-Year,13th month and others benefits available * Company Employees Cooperative available * HMO,COOP support available * Doctor and Nurses, Drivers and Helper support available * Employment agency / BPO support available. * Government payroll support available * support for biometric devices available ( part of HRIS - Time and Attendance ) * Project Time Management System available as replacement for bio-metric ( part of HRIS - Time and Attendace ) * Multiple option on Statutory Deduction * 100% Government Compliance * Sending Payslip via email this payroll is ideal for : Private, Government, Project Based Payroll, Employment Agency, Hospital, Trucking, Cooperative and...
Words: 353 - Pages: 2
...Unit 3 Individual Project Victoria Kane MGMT305-1301A-04 Management Information Systems March 3, 2013 American Intercontinental University Abstract The paragraphs below will detail the technicalities of an e-commerce website for Steve’s Used Appliances. Unit 3: E-Commerce and System Design When starting up an e-commerce website, the first thing to decide upon is the type of business model that will be used for the foundation of the website. The internet business model that best applies to Steve’s Used Appliances is affiliate marketing. In this model, a business pays off one or more affiliates for their marketing efforts to broaden the scope of customers. (Boris, 2011) This model will be the most helpful for a used appliance store because of the fact that appliances are not easy to sell. Having an affiliate model opens the door for other larger businesses to spread the word on this smaller business. Steve’s Used Appliances can definitely benefit from the creation of an e-commerce website. Having a website will make it possible for the company to get out information about their products and services without wasting money on postage, publicizing, or couriers. It also makes it possible for this small business to reach customers from cities farther away than they would with simple newspaper ads or commercials. An e-commerce website also provides several functions for a business. These functions are usually in reference to marketing, sales, customer support, and internal...
Words: 828 - Pages: 4
...configuration management, documentation and closure with cross-cultural teams, * Demonstrated excellence in development of various enhancements that not only facilitated development efforts but also made the product truly friendly to customer, * An energetic, self-motivated team member with hands on experience in programming skills, requirements gathering, designing etc. Skills Domain Skills | Web Based Applications | Java/J2EE Technologies | JDK, J2EE | Internet Technologies | HTML, CSS,jQuery | CMS Frameworks | Oracle Webcenter Sites (Fatwire), DOTCMS | ORM Frameworks | Hibernate | Web/App Servers | Apache Tomcat | Java I.D.E /Tools | Eclipse | RDBMS | MySql 5 | Logging | Apache Log4J, Commons logging | Operating Systems | Windows 98/XP/Windows7, LINUX | Database Tools | SQL Yog, MySql Query Browser....
Words: 966 - Pages: 4
...Anik Mondal Email: anik28042012@gmail.com Permanent Address: Mobile No : +918697070645 Flat No 8,60/11,Andul 1st Bye lane,P.O – Danesh sk lane P.S – Shibpur,Dist – Howrah,West Bengal - 711109 |Career Objective | To work in a productive environment with ample opportunities to build strong technical and professional skills and to experience sustained career growth. |Professional Summary | • Having experience in developing client/server web application using Java/J2EE technology • Proficient in use of Struts , Spring and Hibernet Framework • Good knowledge in exposing and consuming Web services • Versatile in J2EE technologies specially Servlets, JSP, JDBC, EJB • Good Knowledge in Java server programming and MVC-architecture |Working Profile | . Worked at Platoon Technologies...
Words: 705 - Pages: 3
...------------------------------------------------- Benefits of MySQL Carrier Grade Edition for Subscriber Databases * Standards Based, Open Source database allows vendors and users of subscriber data management solutions to easily integrate their applications with MySQL Carrier Grade Edition using their preferred database-independent Subscriber API, e.g., LDAP, SQL, C++, Java, HTTP, etc. * High Performance with a Shared-Nothing, Distributed Database that provides realtime access to in-memory subscriber data with just a few milliseconds latency for reads and writes, and can be scaled out by adding additional resources or by storing data on disk. * 99.999% Availability achieved by synchronously replicating in-memory data across active nodes in the cluster with recovery data being asynchronously written to disk, and by optionally “geo”-replicating data off-site to a remote active or standby cluster. * Self-Healing of data nodes with sub-second fail-over times, and an optimized node recovery protocol that automatically re-synchronizes data across re-starting data nodes. Geo-replication enables self-healing across dispersed sites, where the system can continue functioning correctly in the event of site failure. * Distribution-Awareness in a Shared-Nothing Database is enabled in MySQL Cluster with the partitioning of tables by subscriber identifiers, and by using those identifiers when accessing subscriber data to ensure that reads/writes are localized to the data...
Words: 407 - Pages: 2
...Stored Procedures and Views • Do not preface a stored procedure with sp_. Commonly accepted prefixes are: 1. sp or s (vw or v for views) 2. s21 where the 21 refers to the program number that uses this SP. This has the advantage of keeping all SP's for program 21 together. • The balance of the name should include a description of its action, e.g. 1. UpdateInvoice (note the use of Proper Case and no underscores) 2. InsertEmployee 3. SelectCustomer 4. FindInvoiceItem User Defined Functions • A prefix isn't needed for two reasons: 1. When a function is called it must be prefaced by the owner’s name, e.g. dbo.FunctionName. 2. You shouldn't be writing very many UDFs as they are inefficient. Table Names • Table names require no prefix to identify them as their use makes it fairly obvious as long as Views have a prefix. • Use descriptive names, no abreviations and no plurals. Some writers prefer to use plural where it seems appropriate, but my quarrel with them is that it is very difficult for everyone to agree when it is appropriate. Consequently, it is easier to leave no doubt and make them singular. • Designate look-up tables with either a prefix or suffix that will always indicate the tables purpose, e.g. luTableName or TableNameLkU. • Designate many-to-many tables (conjoint table) by using an underscore between the associated table names, e.g. Product_Supplier. • Never use a name that requires the use of [ ]. Column Names • Avoid underscores...
Words: 398 - Pages: 2
...Industry - Data Security Standard (PCI-DSS), and the Gramm-Leach-Bliley Act (GLBA). We must comply with SOX, because we are a publicly-traded financial institution; PCI-DSS, because we process online credit card transactions; and GLBA, because we are a financial institution. All of the regulations of these three compliancy laws must be met, while still maintaining the Confidentiality, Integrity, and Availability (CIA) triad. All security requirements for SOX, PCI-DSS, and GLBA can be achieved using Linux and open source infrastructure. Some examples of open source software that we might use are: Web Server - Apache Web Filtering - DansGuardian Network Firewall - Turtle Firewall VPN - Endian Firewall Community IDS/IPS - Suricata Database - MySQL File Server - Samba SMTP Server - hMailServer I would recommend that we use a "Defense in Depth" strategy, having multiple layers of access protection. We need to have an IDS/IPS on both sides of our edge firewall. The inside IDS/IPS will be used as additional protection for our network and the outside IDS/IPS will serve as an early warning system from attacks. We will also use the outside IDS/IPS for additional protection and to monitor what types of attacks are occurring. Our web server and mail server should be completely separated from the rest of our network in a de-militarized zone (DMZ). We need to have a network firewall between our DMZ and our internal...
Words: 964 - Pages: 4
...Chapter-1 1.1 Introduction Android is an software platform and operating system for mobile devices. It is based on the Linux kernel. It was developed by Google and later the Open Handset Alliance (OHA). It allows writing managed code in the Java language. Due to Android here is the possibility to write applications in other languages and compiling it to ARM native code. Unveiling of the Android platform was announced on 5 November 2007 with the founding of OHA. It's a consortium of several companies 1.1.1 Introduction to Project Environment OPERATING SYSTEM: An operating system (OS) is software consisting of programs and data hostel management system project report runs on computers and manages computer hardware resources and provides common services for efficient execution of various application software. For hardware functions such as input and output and memory allocation, the operating system acts as an intermediary between application programs and the computer hardware, although the application code is usually executed directly by the hardware and will frequently call the OS or be interrupted by it. Operating systems | | Common Features: * Process management * Interrupts * Memory management ...
Words: 15019 - Pages: 61
...Technology from XYZ Institute of Technology, Indore. * Proficient in finding and resolving malfunctions, using exceptional technical and communication skills. * Ability to express technical concepts clearly to people with no technical background. * Worked on academic project Restaurant Billing System and Staff Management System. * Adept in database MySQL and Programming language JAVA and Internet Applications. * Conversant with Bootstrap 3, Drupal, Wordpress, Adobe Dreamweaver and Big Data Handoop. * An effective communicator with excellent interpersonal, logical thinking & analytical abilities. ------------------------------------------------- ACADEMIC PROJECTS Project Title : Restaurant Billing System Organization : Tata International Ltd. Platform Used : C++ Contribution : Analysis and Coding Description : This project dealt with avoiding paper work in restaurants and switching over to computerized billing of items for a well organized manner. Project Title : Staff Management System Organization : College Staff Management Platform Used : JAVA as programming language and MYSQL as database. Contribution : Analysis and Coding...
Words: 369 - Pages: 2
...PHP PHP code can be included alone inside a file or can be embedded inside the html code and runs on webserver. The PHP files have extension of .php. The PHP code syntax is: <?php ‘code goes here’ ?> We have to use semi colon at the end of each command/line. If we only have php code in a file, then we need to make sure that there is no space before the opening php tags or after the closing php tag. If the file extension is .php then we can only view that file through web browser where php is installed even if the file does not have any php code. On our local servers we need to store the files in the root folder, which for WAMP is C:\wamp\www. We also need to make sure that the local server is running. The local port is 80, if we are using a different port than standard then we need to specify that e.g. http://localhost:8888/. We can have as many blocks of php codes inside html as we want. However, we cant nest one php code inside another. We can also insert php code above the html code and that works perfectly fine. The php code directly works with the database so if we are not outputting anything in html the code above html code works just fine. . Period: Period is used to concatenate two strings. Variable: In PHP all variable name start with ‘$’ sign e.g. $name = ‘Ali’;. Remember ‘$this’ is a reserved variable so don’t use this. Some people use parenthesis around variable but it is completely optional to use. String: The php string works the same way...
Words: 5458 - Pages: 22
...Databases in use:- 1. Mysql What is MS SQL? It is a relational web hosting database that is used to store web site information like blog posts or user information. MS SQL is the most popular type of database on Windows servers. It is not free but it has many advanced features that make it suitable for businesses. What is MS SQL capable of? In basic terms, an MS SQL database is capable of storing any type of that you want. It will let you quickly store and retrieve information and multiple web site visitors can use it at one time. You will use SQL statements to accomplish all of this. In more technical terms, most versions of MS SQL have the following features: • Buffer management • Logging and Transaction • Concurrency and locking • Replication services • Analysis services • Notification services • Integration services • Full text search service • Stored procedures • Triggers • Views • Sub-SELECTs (i.e. nested SELECTs) What is MS SQL used for? MS SQL is the database of choice for web applications on a Windows platform (using .NET or ASP). These languages make is extremely easy to connect to a MS SQL database. It is also used for many popular content management systems and other scripts. Learn more about what is MS SQL on its official website. They have comprehensive learning material. You should also check out the SQL tutorial on W3Schools and some articles on the SQL Community Server blog. If you are looking for a web host that supports MS SQL, look at...
Words: 2647 - Pages: 11
...documentation of a student management system program testing. The application is java based and using a client/server model wherein which the client inputs, updates and queries to a MySQL database on server end. The database stores student information and data. The information stored by the database is first name, last name, student ID, mentor, GPA , student status, thesis title and thesis advisor for graduate students.. The program also determines tuition cost based on the type of student and enrolled credit hours. The tuition is calculated for undergraduate, graduate and part-time. The program is to provide a tool to add, modify, query and delete student records. There are many methods of testing software applications. The testing performed in this documentation is to test the functionality of the program. The testing did not go in depth as far as looking at the specific code. The testing checks the user interface, which is command line in the program, database(MySQL), client and server functionality. The testing is performed manually from the end user point as documented in the herein contained Test Cases. The following requirements must be met to run the program: Java Integrated Development Environment (IDE), MySQL database. Netbeans 7.0.1 was utilized in making the program and testing it . MySQL is open source SQL database. They both can be downloaded for free of charge. Windows 7 OS was used to host both pieces of software. There are minimum requirements that can...
Words: 929 - Pages: 4
