CS403 GDB Idea Solution Spring July 2012

CS403 GDB Idea Solution  Spring July 2012

Let suppose you are hired as a Database Administrator (DBA) for a renowned IT service provider company with a task that you are required to choose any one from the given options Microsoft SQL Server, Oracle and MySQL in order to manage data about 5000 employees and its related transactions.
Its also one of the main requirement of the company to secure data as much as possible.
Highlight with very solid points (not more than 5) which RDBMS is more appropriate from your point of view.
Solution:-

A short definition of an RDBMS is: a DBMS in which data is stored in tables and the relationships among the data are also stored in tables. The data can be accessed or reassembled in many different ways without having to change the table forms.
according to my opinion based on security ORACLE is far better than others..
Oracle is more stable, more robust, and more secure
Oracle is premium soft, it is best for any system setup relational database, many supporting tool , but no free.
Oracle is more geared towards and thus may perform better with very large deployments, it is true, but the thing that actually makes a difference is having optimized queries and sensible indices.
It really depends on what you want to use it for. Oracle is better for larger sites (it's better at handling a lot of simultaneous requests at once).

MYSQL I'd say is easier to use and there are a lot more resources out there for it than Oracle.

IDEA Solution:-

Microsoft SQL Server has a stronger security posture than the Oracle RDBMS.

DISADVANTAGE PRESENT IN MYSQL:

MYSQL standard has diverted on the standards of implementation of Null and default values. Arithmetic operations are susceptible to integer over flow. Mode of operation of SQL is set to unusual tolerant state which developers hate.
MySQL does not support a very large database size as efficiently
MySQL does not support ROLE, COMMIT, and Stored procedures in versions less than 5.0
Transactions are not handled very efficiently.

---

Advantages of MySQL over Oracle :

MySQL is characterised as a fast, robust database with a good feature set, but one which lacks all the extras of something like Oracle ... so if you're writing code that's designed to be portable it's a pretty good choice. Admin / security are effective but the setup of these and othe features isn't over-complicated. All in all, a pretty good choice for many "middle of the road" requirements.

MySQL is characterised as a free, fast, reliable open source relational database. It does lack some sophistication and facilities, but it has an active development team and, as it goes from release to release, more capabilities are added. At certain times there will be a trade-off between speed and capabilities, and the MySQL team intend to keep their database engine fast and reliable.


Advantages of Oracle over MySQL :

Oracle is much versatile than MySQL. Oracle can run and handle more transactions than MysQL. Oracle would be better if you are going to have lots of db usage.

I've used MySQL. Only for a forum. Still, MySQL takes up resources with PHP that affected the server load. Oracle on the other hand is better with memory leaks and handles multiple threads. You can do SQL Transactions, stored procedures, DTS in Oracle that you can not do in MySQL earlier versions.

Oracle is expensive, although they came out with Oracle Free Edition to attract MySQL users.

MySQL users enjoy this database because it is available on virtually all hosting companies. Oracle are only limited to large corporations due to licencing costs and not all hosting companies have Oracle (they might have SQL Server, but not Oracle).

You can make billions of data with MySQL, but it will be slow on the server. In addition, backing up the MySQL database takes forever, versus Oracle's tools which makes database backup a cinch.

If you are going to use MySQL, then add lots of memory. In addition, I recommend that you seperate the Website from the database. In other words, have emails and website on a seperate server and only have a dedicated MySQL server specific to mysql/db only.

MySQL is Free, It's everwhere, that's the whole concept!!!

---

MYSQL and SQL me se to SQL he best hai esko read kro. ab hme SQL and ORACLE ka comparison krna chaheay.

To give a better idea of the differences in MySQL and SQL Server, MySQL is geared more toward selecting data so is can be displayed, updated and saved again. MySQL is weaker in the areas of inserting and deleting data. MySQL is an excellent choice, for other reasons that we will discuss later on, for data storage and referencing data. MySQL is not the best choice however, for creating, inserting and deleting data from tables on the fly.
For an Internet application, MySQL would be a good choice for tracking clients and creating dynamically populated pages with information from the database. For an application of moderate to large scale that is used for commerce of any kind, SQL Server is by far the better choice with more options and functionality to add, manipulate, update and delete data.
Following are some specific technical differences in MySQL and SQL Server when it comes down to the ANSI SQL standard:
MySQL does not support Triggers, SQL Server does.
MySQL does not support User Defined Functions, SQL Server does.
MySQL does not have Cursor Support, SQL Server does.
MySQL does not support Stored Procedures, SQL Server does.
MySQL does not have FULL JOIN capabilities, SQL Server does.
MySQL has limited Import/Export capabilities, SQL Server has full support for Import/Export.
MySQL has limited Transaction Support while SQL Server offers full Transaction Support.
So, it becomes clear that SQL Server is an obvious choice for the company or individual that needs to have FULL control over their data to manipulate and change it as they need.
The following table shows a more complete comparison of the differences between MySQL and SQL Server:
Feature
MySQL 4.1
SQL Server 2000
Notes
SQL VIEW support

SQL VIEWS let administrators abstract database designs away from developers.
Triggers

Lack of triggers makes MySQL developers add extra logic to their front end and middle tier when the logic should go into the database.
Stored Procedures

Stored procedures are mechanisms for abstraction and security
User Defined Functions

User Defined Functions (UDFs) allow encapsulation of complex code into simple callable interfaces.
CURSOR Support

Lack of CURSOR support in MySQL increases network traffic and lowers app response time.
SQL SELECT

MySQL supports using a regular expression as a filter clause in a query.
XML Support

XML is a standards-based format for data. MySQL has no native support for XML.
FULL JOIN

MySQL does not support FULL JOIN
Referential Integrity

MySQL 4.0 supports referential integrity (RI) so long as the InnoDB table type is chosen.
Transaction Support

MySQL´s default installation does not support transactions. Transaction support requires InnoDB.
Full Text Support

Import/Export Support

Replication Support

Auto Tuning

Database Management Tools

Query Analysis Tools

Job Scheduling

Profiling

Online backup support

Clustering Support

Log Shipping

Support for Storage Area Networks (SANs)

Hot Backups / Incremental backups

Basic Security

Security Certifications

Security Tools

Security through stored procedures & views

OLAP Services

Data Mining

Data Reporting

Security Support
Another major concern to business today is security. While data management can seem to be a mundane process at times, securing critical data from "the outside world" is an ever increasing and trying task.
While is good to know that your database management system (MySQL or SQL Server) utilize security features it is very important to know that the application has been verified by a third party. SQL Server has been certified as C2 compliant, which ensures that the database has adequate security support for government applications.
Along with C2 certification, Microsoft Baseline Security Analyzer helps administrators ensure that their SQL Server installations are up to date with the most current patches and security features. MySQL has no equivalent tool to protect and ensure the same confidence in their platform.
While both MySQL and SQL Server support security measures within in their platforms, MySQL supports security via the SQL GRANT command. The MySQL GRANT command is limited to granting security at the table level. This means that if any portion of data in the table needs to be secure from any particular user, then the entire table has to be secured from that user. SQL Server supports security at the column level, meaning that any portion of data in a table can be secured from any particular user while allowing that same user to see other portions of the table data.
SQL Server also makes their database more secure by abstracting its data behind a layer of stored procedures. This ensures that developers never see how the actual data is represented. My SQL, as noted above, does not support stored procedures.
Data Protection
Another security aspect is the protection from loss of data due to power failure. Database administrators in large environments employ the concept of "warm standby servers". This is an additional server containing duplicate data that, by normal use, is not accessed until an event such as a power failure of the main server. Standby servers are kept in a ready state using a concept known as log shipping. Log shipping takes a regularly scheduled backup (sometimes at intervals of less than 10 seconds) of a database and stores that data on the duplicate standby server´s hardware.
MySQL lacks the capability to perform such a backup transaction in an online, or "live" environment. This feature is standard to SQL Server and includes tools to help the database administrator manage the details of the log shipping.
Support and Service
When deciding on how you want to manage your data, you must also consider what kind of support you can expect to receive from the manufacturer of your data management application. After all, if you can´t figure out how to make it work for you, you can´t make any use of your data.
MySQL and SQL Server both offer support plans that are available from their respective vendors. Both applications offer some free support as well as some paid support options and plans.
MySQL claims to employ about 100 people worldwide, which makes up the entire company consisting of product development, support staff, sales staff, distribution, and clerical workers. With such a small staff dispersed over a wide area of expertises, this fact may worry some database administrators.
SQL Server, from Microsoft, has a significantly large support program and large staff backing the program.
Pricing!
Now, let´s move on to the biggest issue of them all. Pricing! Let´s start with MySQL, how does FREE sound? Well, while MySQL is an open source database management tool, it does have its retractions on that $0.00 price! MySQL can be used, for free, for any purpose whether its used to manage a large companies data or to spice up a hobbyist´s web site.
SQL Server on the other hand, could take a small independent company´s budget and eat it for lunch! However, the many outstanding features that are far and away above MySQL offset the price paid for SQL Server drastically.
Conclusion
Now that we have taken a good look at the defining differences between MySQL and SQL Server, its plain to see that the final decision will come down to your needs. How flexible do you need your data to be? How secure must your data be? Do you need support in utilizing your data management tools? These are all questions that you will have to answer for yourself. And in answering them, you will know which data management tool will be best suited for your personal, business or corporate needs.
From a database developer´s standpoint, the choice is clear. SQL Server is the most sensible choice because of its rich features in manipulating, securing and managing data. Also, from a developer´s stand point, MySQL´s lack of support for the basic database features mean that development of an application to interface with the database will be both more costly and take longer to finalize. Too much code must be written in the user interface to manipulate the data first, before sending that data to the database. All this extra code costs time and money to develop and maintain.

CS201 Assignment # 5 Idea Solution Spring July 2012

 CS201 Assignment # 5 Idea Solution Spring July 2012

#include<iostream>

#include<conio.h>

#include<stdlib.h>

using namespace std;

class Customer

{

      private:

              string Name;

              int CustomerId;

              int Spending;

              int tax;

              int discount;

              int totalbill;

      public:

             void setName(string);

             int setCustomerId(int);

             int setSpending(int);

             int getName(string);

             int getCustomerId(int);

             int getSpending(int);

             void display()

             {

                  cout<<"Customer Name : "<<Name<<endl<<endl<<"ID : "<<CustomerId<<endl<<endl<<"Spending : "<<Spending<<endl<<endl;

             }

             Customer();

             Customer(string, int, int);

             friend ostream & operator<<(ostream &, Customer&);

             friend istream & operator>>(istream &, Customer&);

             friend ostream &star(ostream &);

};

ostream & star(ostream & output)

{

        output<<"*";

        return output;

}

Customer::Customer()

{

                    Name="No Name";

                    CustomerId=0;

                    Spending=0;

}

Customer::Customer(string s, int i, int j)

{

                          Name=s;

                          CustomerId=i;

                          Spending=j;

}

istream & operator>>(istream & input, Customer &c)

{

        cout<<"Enter the name of customer : ";

        input>>c.Name;

        cout<<"Enter the customer-id : ";

        input>>c.CustomerId;

        cout<<"Enter the Spending : ";

        input>>c.Spending;

        return input;

}

ostream & operator<<(ostream & output, Customer &c)

{

        for(int i=0;i<55;i++)

        {

                if(i==25)

                {

                         output<<"Customer Bill Information";

                }

                else

                {

                    output<<star;

                }

        }

        output<<endl;

        output<<"Name :";

        for(int a=0;a<21;a++)

        {

                if(a==20)

                {

                 output<<c.Name<<endl;

                }

       

                else

                {

                 output<<star;

                }

        }

        output<<"ID :";

        for(int a=0;a<23;a++)

        {

        if(a==22)

                {

                 output<<c.CustomerId<<endl;

                }

       

                else

                {

                 output<<star;

                }

        }

        output<<"Spending :";

        for(int a=0;a<19;a++)

        {

        if(a==18)

                {

                 output<<c.Spending<<endl;

                }

       

                else

                {

                 output<<star;

                }

        }

      

        if(c.Spending<=5000)

        {

                         c.tax=(c.Spending*5)/100;

                         c.discount=(c.Spending*1)/100;

                         c.totalbill=c.Spending+c.tax-c.discount;

                         output<<"Tax :";

                                      for(int a=0;a<27;a++)

                                      {

                                              if(a==26)

                                              {

                                               output<<c.tax<<endl<<"Discount :";

                                                   for(int a=0;a<19;a++)

                                                   {

                                                       if(a==18)

                                                       {

                                                         output<<c.discount<<endl<<"Total Bill :";

                                                             for(int a=0;a<17;a++)

                                                             {

                                                                if(a==16)

                                                                {

                                                                  output<<c.totalbill<<endl;

                                                                  }

       

                                                                      else

                                                                      {

                                                                        output<<star;

                                                                      }

                                                                  }

                 

                                                                 }

       

                                                              else

                                                              {

                                                               output<<star;

                                                              }

                                                         }

                

                

                                                    }

       

                                                 else

                                                 {

                                                  output<<star;

                                                  }

                                              }

                        

                                          }

        else if(c.Spending>5000 & c.Spending<10000)

        {

             c.tax=(c.Spending*10)/100;

                         c.discount=(c.Spending*2)/100;

                         c.totalbill=c.Spending+c.tax-c.discount;

                         output<<"Tax :";

                                      for(int a=0;a<27;a++)

                                      {

                                              if(a==26)

                                              {

                                               output<<c.tax<<endl<<"Discount :";

                                                   for(int a=0;a<19;a++)

                                                   {

                                                       if(a==18)

                                                       {

                                                         output<<c.discount<<endl<<"Total Bill :";

                                                             for(int a=0;a<17;a++)

                                                             {

                                                                if(a==16)

                                                                {

                                                                  output<<c.totalbill<<endl;

                                                                  }

       

                                                                      else

                                                                      {

                                                                        output<<star;

                                                                      }

                                                                  }

                 

                                                                 }

       

                                                              else

                                                              {

                                                               output<<star;

                                                              }

                                                         }

                

                

                                                    }

       

                                                 else

                                                 {

                                                  output<<star;

                                                  }

                                              }

                        

                                          }

        else if(c.Spending>10000)

        {

             c.tax=(c.Spending*15)/100;

                         c.discount=(c.Spending*3)/100;

                         c.totalbill=c.Spending+c.tax-c.discount;

                         output<<"Tax :";

                                      for(int a=0;a<27;a++)

                                      {

                                              if(a==26)

                                              {

                                               output<<c.tax<<endl<<"Discount :";

                                                   for(int a=0;a<19;a++)

                                                   {

                                                       if(a==18)

                                                       {

                                                         output<<c.discount<<endl<<"Total Bill :";

                                                             for(int a=0;a<17;a++)

                                                             {

                                                                if(a==16)

                                                                {

                                                                  output<<c.totalbill<<endl;

                                                                  }

       

                                                                      else

                                                                      {

                                                                        output<<star;

                                                                      }

                                                                  }

                 

                                                                 }

        

                                                              else

                                                              {

                                                               output<<star;

                                                              }

                                                         }

                

                

                                                    }

       

                                                 else

                                                 {

                                                  output<<star;

                                                  }

                                              }

                        

                                          }

return output;

}

main()

{

      Customer obj;

      cin>>obj;

      cout<<obj;

      system("pause");

}

MTH401 Assignment 3 Solution Spring July 2012

MTH401 Assignment 3 Solution Spring July 2012

MTH401 Assignment 3 Solution -

ENG201 Assignment # 4 Idea Solution Spring July 2012

 ENG201 Assignment # 4 Idea Solution Spring July 2012

Answer 1:

Types of Visual Aids:

Objects

The use of objects as visual aids involves bringing the actual object to demonstrate on during the speech. For example, a speech about tying knots would be more effective by bringing in a rope.
Pro: the use of the actual object is often necessary when demonstrating how to do something so that the audience can fully understand procedure.
Con: some objects are too large or unavailable for a speaker to bring with them.

Models

Models are representations of another object that serve to demonstrate that object when use of the real object is ineffective for some reason. Examples include human skeletal systems, the solar system, or architecture.
Pros: models can serve as substitutes that provide a better example of the real thing to the audience when the object being spoken about is of an awkward size or composure for use in the demonstration.
Cons: sometimes a model may take away from the reality of what is being spoken about. For example, the vast size of the solar system cannot be seen from a model, and the actual composure of a human body cannot be seen from a dummy.

Graphs

Graphs are used to visualize relationships between different quantities. Various types are used as visual aids, including bar graphs, line graphs, pie graphs, and scatter plots.
Pros: graphs help the audience to visualize statistics so that they make a greater impact than just listing them verbally would.
Cons: graphs can easily become cluttered during use in a speech by including too much detail, overwhelming the audience and making the graph ineffective.

Maps

Maps show geographic areas that are of interest to the speech. They often are used as aids when speaking of differences between geographical areas or showing the location of something.
Pros: when maps are simple and clear, they can be used to effectively make points about certain areas. For example, a map showing the building site for a new hospital could show its close location to key neighborhoods, or a map could show the differences in distribution of AIDS victims in North American and African countries.
Cons: inclusion of too much detail on a map can cause the audience to lose focus on the key point being made. Also, if the map is disproportional or unrealistic, it may prove ineffective for the point being made.

Tables

Tables are columns and rows that organize words, symbols, and/or data.
Pros: Good tables are easy to understand. They are a good way to compare facts and to gain a better overall understanding of the topic being discussed. For example, a table is a good choice to use when comparing the amount of rainfall in 3 counties each month.
Cons: Tables are not very interesting or pleasing to the eye. They can be overwhelming if too much information is in a small space or the information is not organized in a convenient way. A table is not a good choice to use if the person viewing it has to take a lot of time to be able to understand it. Tables can be visual distractions if it is hard to read because the font is too small or the writing is too close together. It can also be a visual distraction if the table is not drawn evenly.

Photographs

Pros:Photographs are good tools to make or emphasize a point or to explain a topic. For example, when explaining the shanty-towns in a third word country it would be beneficial to show a picture of one so the reader can have a better understanding of how those people live. A photograph is also good to use when the actual object cannot be viewed. For example, in a health class learning about cocaine, the teacher cannot bring in cocaine to show the class because that would be illegal, but the teacher could show a picture of cocaine to the class. Using local photos can also help emphasize how your topic is important in the audience's area.
Cons: If the photograph is too small it just becomes a distraction. Enlarging photographs can be expensive if not using a power point or other viewing device.

Drawings/Diagrams

Pros: Drawings or diagrams can be used when photographs do not show exactly what the speaker wants to show or explain. It could also be used when a photograph is too detailed. For example, a drawing or diagram of the circulatory system throughout the body is a lot more effective than a picture of a cadaver showing the circulatory system.
Cons:If not drawn correctly a drawing can look sloppy and be ineffective. This type of drawing will appear unprofessional.

Visual Aids Media: Simple to Advanced

Chalkboard or Whiteboard

Chalkboards and whiteboards are very useful visual aids, particularly when more advanced types of media are unavailable. They are cheap and also allow for much flexibility.  The use of chalkboards or whiteboards is convenient, but they are not a perfect visual aid. Often, using this medium as an aid can create confusion or boredom. Particularly if a student who is not familiar with how to properly use visual aids attempts to draw on a board while they are speaking, they detract time and attention from their actual speech.

Poster Board

A poster is a very simple and easy visual aid. Posters can display charts, graphs, pictures, or illustrations. The biggest drawback of using a poster as a visual aid is that often a poster can appear unprofessional. Since a poster board paper is relatively flimsy, often the paper will bend or fall over. The best way to present a poster is to hang it up or tape it to a wall.

Handouts

Handouts can also display charts, graphs, pictures, or illustrations. An important aspect of the use of a handout is that a person can keep a handout with them long after the presentation is over. This can help the person better remember what was discussed. Passing out handouts, however, can be extremely distracting. Once a handout is given out, it might potentially be difficult to bring back your audience’s attention. The person who receives the handout might be tempted to read what is on the paper, which will keep them from listening to what the speaker is saying. If using a handout, the speaker distributes the hand out right before you reference it.Distributing handouts is acceptable in a lecture that is an hour or two, but in a short lecture of five to ten minutes, a handout should not be used.

Video Excerpts

 A video can be a great visual aid and attention grabber, however, a video is not a    replacement for an actual speech. There are several potential drawbacks to playing a video during a speech or lecture. First, if a video is playing that includes audio, the speaker will not be able to talk. Also, if the video is very exciting and interesting, it can make what the speaker is saying appear boring and uninteresting. The key to showing a video during a presentation is to make sure to transition smoothly into the video and to only show very short clips.

Projection Equipment

There are several types of projectors. These include slide projectors, PowerPoint presentations, overhead projectors, and computer projectors. Slide projectors are the oldest form of projector, and are no longer used. PowerPoint presentations are very popular and are used often. Overhead projectors are still used but are somewhat inconvenient to use. In order to use an overhead projector, a transparency must be made of whatever is being projected onto the screen. This takes time and costs money. Computer projectors are the most technologically advanced projectors. When using a computer projector, pictures and slides are easily taken right from a computer either online or from a saved file and are blown up and shown on a large screen. Though computer projectors are technologically advanced, they are not always completely reliable because technological breakdowns are not uncommon of the computers of today.

Computer-Assisted Presentations

PowerPoint presentations can be an extremely useful visual aid, especially for longer presentations. For five to ten minute presentations, it is probably not worth the time or effort to put together a PowerPoint. For longer presentations, however, PowerPoints can be a great way to keep the audience engaged and keep the speaker on track. A potential drawback of using a PowerPoint is that it usually takes a lot of time and energy to put together. There is also the possibility of a computer malfunction, which can mess up the flow of a presentation.

Answer 2:

     

1:    Alina served hot sandwiches, fries, and potato salad on paper plates to her guests.

2:    The stolen red sports car was reported by the police officer.

3:    While on my bike, I saw the farmer who was covered with dirt plowing his field.

4:    While I was lacing my shoelaces, the cat yawned and settled into the chair.

5:     we were uncomfortable in the car during the trip