CS403 Assignment No. 5 Announced

Assignment No. 05

Semester Fall2010

Database Management Systems-CS403

Due Date: 03/02/2011

Q 1: Write SQL statements/queries for each of individual scenario given below from the given tables on the next page. 15 marks (3+4+4+4)

1. Create a simple view showing the names of employees whose designation is ”Instructor”

2. Create a view to list down employees name and designation of Computer sciences Department

3. Update view to change designation from instructor to lecturer of employee “Ali hassan”

4. Create a view to show number of courses student “VU

Mgt401 Assignment No. 2 solution

Assignment No. 02 Marks: 10

Question

During 2009, company XYZ Ltd. found that certain items had been included in the inventory at 31^stDec, 2008, valued at Rs.4.5 millions which had in fact been sold before the year end. The following figures were reported for the year 2008:

Rs. (‘000)

Sales 50,400

Cost of goods sold (34,570)

Profit before taxation 15,830

Income tax (4,749)

Net Profit 11,081

While the draft figures for the year 2009 are as follows:

Rs. (‘000)

Sales 70,000

Cost of goods sold (55,800)

Profit before taxation 1 4,200

Income tax (4,260)

Net Profit 9,940

The cost of goods sold for the year 2009 includes the value of error in inventory equal to Rs.4.5 millions. Income tax is applied on the company by the taxation agency. 30 % p.a.

Requirement

Prepare the restated income statements for the year 2009 and 2008 as comparative by adjusting the aforementioned inventory error. Show the related calculations of inventory error adjustment as it also carry marks.



Opening Date and Time: January 26th, 2011 At 12:01 A.M. (Mid-Night)
Due Date and Time: January 31st , 2011 At 11:59 P.M. (Mid-Night)
.................
bacis idea of assignment, company has made the entry of cost
CGS 4.5 million
to
Inventory 4.5 million
but did not enter sales so sale should be credited with 4.5 million in 2008
Inventory 4.5 million
to
sales 4.5 million
it mean sale will be added by 4.5 million in 2008's income statement but CGS remains same

now move to 2009
sale had already been adjusted in 2008 so it will be unchanged in 2009 but CGS in which 4.5 million has added due to missing entry of sale in 2008 that’s why entry will be reversed
Opening Inventory
to
CGS
it mean 4.5 million will be less in CGS of 2009.

CS403 GDB Idea Solution

Just take the idea not copy paste

Question:-

When data is manipulated, the indexes have to be updated. This slows down data manipulation.

Answer:-

Search engine indexing collects, parses, and stores data to facilitate fast and accurate information retrieval. Index design incorporates interdisciplinary concepts from linguistics, cognitive psychology, mathematics, informatics, physics, and computer science. An alternate name for the process in the context of search engines designed to find web pages on the Internet is Web indexing. So doing all this operation indexes have to be updated which causes slow manipulation. Because this operation causes the index to be modified and requires additional updating of each index on that table, SQ L has to internally maintain the “pointers” to the inserted rows in the actual data file, each index potentially adds an alternative access path for a query for the optimizer to consider, which increases the compilation time.

STA301 Assignment No. 4 Announced

Assignment No.4 (Course STA301)

Fall 2010 (Total Marks 30)

Deadline

Your Assignment must be uploaded/ submitted before or on 23:59 Feb 03, 2011

(STUDENTS ARE STRICTLY DIRECTED TO SUBMIT THEIR ASSIGNMENT BEFORE OR BY DUE DATE. NO ASSIGNMNENT AFTER DUE DATE WILL BE ACCEPTED VIA E.MAIL).

Rules for Marking

It should be clear that your Assignment will not get any credit IF:

The Assignment submitted, via email, after due date.

The submitted Assignment is not found as MS Word document file.

There will be unnecessary, extra or irrelevant material.

The Statistical notations/symbols are not well-written i.e., without using MathType software.

The Assignment will be copied from handouts, internet or from any other student’s file. Copied material (from handouts, any book or by any website) will be awarded ZERO MARKS. It is PLAGIARISM and an Academic Crime.

The medium of the course is English. Assignment in Urdu or Roman languages will not be accepted.

Assignment means Comprehensive yet precise accurate details about the given topic quoting different sources (books/articles/websites etc.). Do not rely only on handouts. You can take data/information from different authentic sources (like books, magazines, website etc) BUT express/organize all the collected material in YOUR OWN WORDS. Only then you will get good marks.

Objective(s) of this Assignment:

The assignment is being uploaded to build up the concepts about sampling techniques and testing of hypothesis. Application of the hypothesis testing and confidence interval.

How to get sample size from the given information.

Concepts about unbiasedness and precision

Assignment # 4 (Lessons 31-40)

Question 1: (Marks: 5x1=5)

Give the answer of short questions.

a) When we use central limit theorem?

b) What is the technique to find the estimates of an infinite population?

c) , what do you say about the estimator T, where is a parameter?

d) How precision of an interval estimate can be increased?

e) If an 85% confidence interval is 27.5< <43.8,>

Question 2: (Marks: 6+4=10)

a) In an finite population with and , find the mean and variance for the sampling distribution of if:

b) Find the value of sample size in case of proportions.

Question 3: (Marks: 5+5+5=15)

Test the hypothesis

The masses, in grams, of thirteen ball bearings seen at random from a batch are

21.4, 23.1, 25.9, 24.7, 23.4, 24.5, 25.0, 22.5, 26.9, 26.4, 25.8, 23.2, 21.9

Calculate a 95% confidence interval for the mean mass of the population.

If n=36, s=9 and t=2, what is the values of?

Fin621 Online Quiz No. 4 Annoucement

Quiz # 4

Dated: Jan 28, 11

Announcement For Quiz

There will be an online Quiz # 4. The Quiz will cover from Lecture # 1 to Lecture # 39.

Quiz Schedule

Opening Date and Time: January 31 , 2011 At 12:01 A.M. (Mid-Night)

Closing Date and Time: February 02 , 2011 At 11:59 P.M. (Mid-Night)

24 hours extra time is not available