SQL

4. The idea of Ford with the development of AutoXchange and Covisint was that they wanted to use technology to connect suppliers, businesses, manufacturers and other companies to a central point with enormous amount of information, prices of parts and materials, the processing of parts, price processing of materials etc. available, with the idea to cut cost and enhance productivity. With a technology system like AutoXchange it creates a large online marketplace with the most recent prices…

4. What is the number of used servers? a. 1 b. 2 c. 3-5 d. >5 Servers used Total Nos. 1 10 2 11 3-5 21 >5 13 1 2 3 to 5 >5 From this observation, it was concluded that numbers of servers were directly proportional to the number of desktops used. 5. What is the number of installed laptops? a.) 1-5 b.) 5-15 c.) 15-30 d.) >30 Number of laptops Total Nos. 1-5 20 5-15 22 15-30 8 >30 5 1 to 5 5 to 15 15 to 30 >30 It was observed that maximum computers and laptop users ranging between…

Segmentation has a great importance in digital image analysis. It is also one of the most difficult low-level image analysis tasks. Many image processing application apply segmentation as primary step. Image segmentation serve a variety of applications, such as handwritten character identification, medical image analysis as breast cancer detection, in infrared image, automatic target recognition, radar image application, and in pattern recognition application...etc. The quality of the…

Non parametric tests It is a hypothesis test which does not need population distribution. For instance there are numerous hypothesis tests which depend upon assumptions that population must be normally distributed along with the parameters. Main advantages of non- parametric tests are that they do not rely on assumptions, so they can be easily used where population is non-normal. One thing to be kept in mind, that these tests may have few assumptions related to the data. They might not be…

Importance of Database Design Principles Introduction Database design is simply a process that produces a database model in detail. A proper database provides us access to up to date information which is accurate. A correct design enables us to learn more and helps in achieving the goals whether it is short term or long term. It helps in bringing change. The terms used in date base are tables. It is the place in which data bases are written. A good data bases divides the information into…

Caution No blank lines is allowed in the MongoDB Script Sampler. If there is a blank line after MongoDB statement, the statement will still be executed but the word “ok” will be displayed in the response. Add new document into the collection Step 1 Change the “Script” area of the MongoDB Script sampler with insert query. In this case, the query of adding document into the collection is shown as follows: db.getCollection('zips').insert({"city" : "BABYLON", "loc" : [ 32.211100, 44.251500 ],…

1. Explain why mandatory access control (MAC) is better than discretionary access control (DAC)? Answer: Both mandatory access control (MAC) and discretionary access control (DAC) are important in a multiple user environment where restrictions are very important. Both are popular access control models. But they have some differences. We will find out these differences and the facts that will prove mandatory access control is better than discretionary access control. Basically, they provide…

D1 - Discuss how potential errors in the design and construction of a database can be avoided. Accidental deletion of fields When a database is being used you might find it easy to accidently delete data which could mean a lot of stress if it is something which is very valuable. One main way to avoid this would be to make sure that back-ups are made of the data, so whatever the matter the data will not be completely lost. Back-ups can be stored on anything like a memory stick or an external…

I am not just myself. I am not just one among the masses, one in a sea of seven billion, one in an infinity of complexity—far from it. I am a library, containing everything, indeed everything, that has touched my life, no matter how small and trivial or how big and traumatic. I am salvation. Physical, spiritual, mental salvation I bring. The feeling of duty and responsibility that brands a savior rides for free in the vehicle I drive on my journey. I am a leader. I must be the overprotective…

1. a) Considering the nature of the represented data, the form of the visual is appropriate and delivers the information in an effective manner. The table presents information clearly and is easy to read (DeSmet 1; What You Need to Know). This choice of visual in a form of table results from the idea that a table can depict a wide range of numerical data and “present several variables for a number of items” (Markel 192). Nevertheless, the table needs a title and the indication of the measure,…