Profile cover photo
Profile photo
FELIX ODENY
58 followers -
www.ankitcodinghub.com
www.ankitcodinghub.com

58 followers
About
Posts

Post has attachment
Q1. Which of the following is a way to minimize software development costs? a. software reuse b. system analysis c. debugging d. software maintenance Q2. How does system software make application development easier? a. it provides reusable utility…

Post has attachment
Quiz Solution
Q1. Which of the following is a way to minimize software development costs?
a. software reuse
b. system analysis
c. debugging
d. software maintenance

Q2. How does system software make application development easier?
a. it provides reusable utility programs
b. it provides system development tools
c. it creates program editors
d. it creates debugging tools

Q3. How do you compute the cycle time of a processor?
a. one divided by the clock rate (in Hz)
b. the clock rate (in Hz) divided by one
c. the processor clock rate (in Hz) divided by bus clock rate (in Hertz)
d. the bus clock rate (in Hz) divided by processor clock rate (in Hertz)

Q4. A load operation copies data from main memory to register memory.
a. true
b. false

Q5. What part of the data hierarchy is contained in a file?
a. record
b. database
c. character
d. field

Q6. A flowchart contains a diamond connected to a rectangle. The rectangle is connected back to the diamond. This is a __.
a. loop structure
b. single-alternative if
c. dual-alternative if
d. sequence structure

Q7. A control break program that calculates totals for each category and a grand total has four modules: startUp, bookListLoop, categoryChange, closeDown. In which module would you expect to see the category total incremented?
a. startUp
b. bookListLoop
c. categoryChange
d. closeDown

Q8. Programming languages that require you to declare the type of data a variable contains are said to be:
a. loosely typed
b. strongly typed
c. dynamically typed
d. weakly typed

Q9. Which of the following choices represents the correct order of precedence from highest to lowest?
a. multiplication, equality, addition, comma
b. equality, comparison, logical and, conditional
c. multiplication, comparison, addition, equality
d. equality, logical or, conditional, compound assignment

Q10. A server-side scripting program can use the value of the ___ attribute to determine how to process form data.
a. method
b. enctype
c. accept-charset
d. action

Q11. The onsubmit and onreset event handlers must return a Boolean value.
a. true
b. false

Q12. Meta tags are HTML tags that summarize Web pages for search engine extraction.
a. true
b. false

Q13. Secure Socket Layer is defined at which layer of the OSI model?
a. Presentation
b. Application
c. Physical
d. Network

Q14. Which of the following is not varied in order to represent data in analog form?
a. Frequency
b. Amplitude
c. Phase
d. Light intensity

Q15. An organization that wishes to accept credit card payments must choose between SSL and S-HTTP.
a. true
b. false

Q16. Data inconsistency exists when different and conflicting versions of the same data appear in different places.
a. true
b. false

Q17. Accurate, relevant, and timely information is the key to good decision making.
a. true
b. false

Q18. There are three different types of anomalies: modification, insertion, and deletion.
a. true
b. false

Q19. One of the advantages of the hierarchical model is the ease of maintaining data integrity.
a. true
b. false

Q20. Given its parent/child structure, the hierarchical model yields integrity and consistency; there cannot be __.
a. a root
b. a large amount of data
c. a child without a parent
d. many transactions

Q21. In network database terminology, 1:M relationships are represented using a database table.
a. true
b. false

Q22. The final outcome of a natural JOIN operation yields a table that does not include the unmatched row.
a. true
b. false

Q23. In a sophisticated application development software, nulls can create problems when using functions such as:
a. COUNT
b. SUM
c. COUNT and AVERAGE
d. COUNT, SUM, and AVERAGE

Q24. The systems development environment in the late 1990s focused on systems integration.
a. true
b. false

Q25. The three key principles of Agile Methodologies include a focus on adaptive rather than predictive methodologies, a focus on people rather than roles, and a focus on self-adaptive processes.
a. true
b. false

0

Post has attachment
Question One Hyponatremia is a decrease in serum sodium concentration that is caused by excess water relative to solute. Question Two The symptoms of hyponatremia vary with the levels of serum sodium concentration. Question Three The interventions, in…

Post has attachment

Post has attachment
DELIVERABLE #5 – MULTIPLE TABLE QUERIES
For this deliverable, you will be writing queries to use the data in the TheHipp database.
STEP 1: Download the SQL script (TheHipp.sql) file attached to assigment IP#4. Run the scripts into MySQL as follows:
 Open the SQL script file using CTRL+SHIFT+O.
 Run the entire script using CTRL+SHIFT+Enter.
STEP 2: For each of the problem statements listed in below, please do the following:
a) Write the SQL query that will achieve the desired result
b) Run the query in the MySQL database.
c) Copy and paste the results of the query below each SQL statement using the format on page 3 of this assignment. If you results have more than 10 rows only copy the first 10 rows.
Each query must satisfy the following criteria:
a) They must not include any extra/unnecessary tables.
b) The results must not include any extraneous columns.
c) All column headings should be meaningful names. Please do not have columns with headings that contain expressions or aggregate functions.
d) They must not use views unless specified in the instructions.
Department of Information Systems & Operations Management
Warrington College of Business Administration, University of Florida ISM 4210
Database Management
Individual Project #5
Version: April 14, 2015
PROBLEM STATEMENTS
1. List the names of the customers in the database who have not bought a single ticket. You must submit two queries: (A) Write this query using a sub-query
(B) Write this query using a join
The output section of MySQL Workbench shows you the Duration for each query. Which query took longer to execute?
2. List the venue name, capacity, total revenue and the number of tickets sold for each venue. Write an efficient query that uses the minimum number of tables required.
3. List the name, revenue (total price paid for all the tickets), the promotion cost, the screen cost and the total profit (revenue – promotion cost – screening cost) for the 5 most profitable movies.
4. List the name, description and Venue ID for each event. In addition, if the event is a movie, list the genre. If the event is a play – list the name of the author. Your table should only have 4 columns. The fourth column should be called ‘Genre/Author’. The results will have the same number of rows as the EventTable.
5. Create a View called TicketDetails that includes all the columns from the Ticket and the Event table for each ticket.
(A) Use the TicketDetails view in a query that returns the following information for each event: EventCode, event name, the number of shows, the screen cost, the total screening cost (number of shows * screening cost), promotion cost, production cost, total cost (total screen cost + promotion cost + production cost), the expected revenue (use the BaseTicketPrice), the actual revenue, the total discounts given (expected revenue – actual revenue) and the profit (all costs – actual revenue)
(B) Use the Customer table and the TicketDetails to list the HippCode, name and email of each customer, along with number of tickets they have bought for theater (plays) and the number of tickets they have bought for movies. Sort your results in the descending order of the total number of tickets. Your results may look like the following but should have 199 rows. HippCode LastName FirstName Email TheaterTickets MovieTickets
29249
Yang
Shengda
shey@yahoo.com
41
4
91179
Burnell
Dana
danburnell@gmail.com
37
4
19670
Hill
Annie
anniehil@outlook.com
36
4
Department of Information Systems & Operations Management
Warrington College of Business Administration, University of Florida ISM 4210
Database Management
Individual Project #5 Template
Version: April 14, 2015
For each query, you must present your results using the following template.
SELECT statement
SELECT * FROM Customer;
0

Post has attachment
For this deliverable, you will be writing queries to use the data in the TheHipp database. STEP 1: Download the SQL script (TheHipp.sql) file attached to assigment IP#4. Run the scripts into MySQL as follows:  Open the SQL script file using CTRL+SHIFT+O.…

Post has attachment
SINGLE TABLE QUERIES Solution
For this deliverable, you will be writing queries to use the data in the TheHipp database.
STEP 1: Download the SQL script (TheHipp.sql) file attached to assigment IP#4. Run the scripts into MySQL as follows:
• Open the SQL script file using CTRL+SHIFT+O.
• Run the entire script using CTRL+SHIFT+Enter.
STEP 2: You must write queries for the problem statements on Page 2 as follows:
• Section 1: Write queries for all 4 problem satetemnts. Each query is worth 1 point.
• Section 2: Write queries for 2 problem statements. Each query is worth 2 points.
• Section 3: Write queries for 2 problem statements. Each query is worth 2 points.
STEP 3: Do the following for each of the problem statements you attempt:
a) Write the SQL query that will achieve the desired result
b) Run the query in the MySQL database.
c) Copy and paste the results of the query below each SQL statement using the format on page 3 of this assignment.
Each query must satisfy the following criteria:
a) They must not include any extra/unnecessary tables.
b) The results must not include any extraneous columns.
c) All column headings should be meaningful names. Please do not have columns with headings that contain expressions or aggregate functions.
Department of Information Systems & Operations Management
Warrington College of Business Administration, University of Florida ISM 4210
Database Management
Individual Project #4
PROBLEM STATEMENTS
Section A: You must respond to ALL 4 of the following:
1. List the LastName, FirstName, Email Address and DonorID for all the customers who are also donors. Sort the results by LastName.
2. How many customers have been verified as students? Your query should return just one value.
3. List the EventCode and the Year for all the shows that are scheduled in the month of December. Your query should display each event code only once.
4. How many events have been scheduled for each venue? Your query should return two columns: the VenueID and the number of events.
Section B: You must respond to 2 of the following:
5. List the number of tickets sold during the month of November 2015. Group your results by show and only list those shows that have sold more than or equal to 10 tickets. Your query should have 4 columns: EventCode, ShowDate, ShowTime and the number of tickets sold.
6. What is the maximum number of tickets that a single customer has bought in one day? You query should have 3 columns (HippCode, Date of Purchase and the number of tickets) and just 1 row in the results.
7. For each of the event show, list the number of tickets that were made available, the number of tickets that were sold and the percentage of tickets that were sold. Your results should not include any rows where the shows were sold out (i.e. shows where all tickets were sold). Your results should look like the table below; but the numbers may differ.
Event Code
Show Date
Show Time
Total Tickets
Tickets Sold
Percentage Sold
802
2014-09-23
07:00:00
50
34
68%
803
2014-10-21
07:00:00
50
40
80%
804
2014-11-18
07:00:00
50
32
64%
Section C: You must respond to 2 of the following:
8. For each sponsor, list the sponsor name, the number of events and the total amount they have donated. Sort your results by donation amount in the ascending order.
9. For the top 5 grossing events, list the event code, number of tickets sold, the date of the first show and the date of the last shows (these may be the same).
10. Write a query that lists the number of tickets sold and the revenue earned for each day of the week. Group your results by year as well and sort them by year and day of the week.
Department of Information Systems & Operations Management
Warrington College of Business Administration, University of Florida ISM 4210
Database Management
Individual Project #4
For each query, you must present your results using the following template.
Problem Statement Number
Query:
SELECT * FROM Customer;
Results

Post has attachment
For this deliverable, you will be writing queries to use the data in the TheHipp database. STEP 1: Download the SQL script (TheHipp.sql) file attached to assigment IP#4. Run the scripts into MySQL as follows: • Open the SQL script file using CTRL+SHIFT+O.…

Post has attachment
For this deliverable, you will be creating the database for the Hippodrome database in MySQL. The relations for the database have been defined as shown on Page 2. Based on this information, you must complete the following: STEP 1: Create a new database in…

Post has attachment
DELIVERABLE #3 – SQL DDL Solution
For this deliverable, you will be creating the database for the Hippodrome database in MySQL. The relations for the database have been defined as shown on Page 2. Based on this information, you must complete the following:
STEP 1: Create a new database in MySQL called TheHipp.
STEP 2: Create all the tables as follows:
• Write the CREATE statements for the table corresponding to each of the relations. You must decide which data types (and field size, when applicable) will be appropriate for each column in each table. Each table must have a Primary Key and the appropriate Foreign keys (if applicable)
• Write at least two ALTER statements to either add columns or Primary Key or Foreign Key constraints to any of the tables.
• Execute all the CREATE and ALTER statements in MySQL.
• Use the DESC commmand to describe each table and include the results as shown in the attached template.
• List all the relationships in your database using the following
SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE WHERE (CONSTRAINT_SCHEMA = 'TheHipp') ;
STEP 3: Insert data into the tables as follows:
1. Write one INSERT statement for each of the tables (you may use any dummy data that you can make up)
2. Write a select statement for each of the table to display the contents of each table.
3. Execute all the INSERT and SELECT statements in MySQL.
NOTE: You may use the snipping tool or screenshot tool to copy the results from the MySQL Workbench to the Word document.
Department of Information Systems & Operations Management
Warrington College of Business Administration, University of Florida ISM 4210
Database Management
Individual Project
Version: October 26, 2015
Department of Information Systems & Operations Management
Warrington College of Business Administration, University of Florida ISM 4210
Database Management
Individual Project #3 Template
Version: October 26, 2015
For each relation, you must present your results using the following template (a blank word document is available on Canvas).
RELATION NAME:
CREATE Statement
CREATE TABLE Customer(
CustomerID INT PRIMARY KEY,
LastName VARCHAR(30) NOT NULL,
FirstName VARCHAR(30)
);
ALTER Statement (Optional)
INSERT statement
INSERT INTO Customer (CustomerID, LastName, FirstName)
VALUES (123456, "Pond", "Amy");
SELECT statement
SELECT * FROM Customer;
DESC statement
DESC Customer;
0
Wait while more posts are being loaded