Database Questions 2

1.      What are the main components of a database? The two main components are the data engine and the data file. Also tables ,records and fields.

2.      What is the difference between a record and a field? A field is a column in a table. Record is a row of data added to this table.

3.      What are primary keys?  What are they used for? Primary keys are a key in a relational database that is unique for each record. It is used to uniquely identify each row in a table

4.      Draw up a table which could be used for data about students who borrow books from a library.  Identify and label a record, a field and the primary key.

5.      Why would we not put the students’ data in the same file as the books?

6.      If data is repeated unnecessarily in a table, it is called redundant.  Why do you think that databases should be designed to minimise data redundancy? if you are sorting a table that has alot of redundant data it takes far too long to organise data.

Database Questions

1. What is a database? An organized body of related information.

 

2. What is the most important function of a database? To organize                  

3. What are the advantages of using a database? Quicker access to data

·        Reduction in data redundancy

·        Easy information tracking and cross-referencing

·        Conversion of raw data into meaningful information

·        Automated routine information management tasks

·        Automatic update of related information

·        On-line access to data through Internet

 

4. The table below contains data about some books in a library.  What other data might be    included in a library’s database about its books?

·        Number of copies in store

·        Number of copies borrowed

·        When brought in store

 

 

BookID	Author	Title	Publisher
222334	Grisham	The Brethren	Arrow
232145	Rowling	Harry Potter	Bloomsbury
218934	Moon	Discover Australia	Random House

 

 

5. What items of data would be relevant for a database in a supermarket?

·        Barcode

·        Number of products left

·        Number of products bought

·        Type of product

 

6. You would expect a video hire shop to have a computerized database.  What is the advantage of this from the owner’s viewpoint?  How would it benefit the customer? It would be very easy as the owner would just need to check on the computer if he’s got the movie and the number of copies left.

 

7. How would you find out about available flights to Europe for the next school holidays?  You would be able to find out about available flights by going to websites that have flight accommodation like flight centre. To find out flights you would see their database.

#5 Virtual Reality

Virtual reality is a technology which allows a user to interact with a computer-simulated environment, be it a real or imagined one. Most current virtual reality environments are primarily visual experiences, displayed either on a computer screen or through special or stereoscopic displays, but some simulations include additional sensory information, such as sound through speakers or headphones.

#4 Simulations

Why is the Simulations used / necessary? 

a simulation is a computer programmed to mimic something else. simulations are used to immitate or process an event and see how it would happen in real life. by using a flight simulator you can practice without having disastrous events occuring like crashing.

What hardware is needed for the Simulation?
Depending on the quality of flight simulator it will use different hardware. these are some examples of hardware used:

DVD Drive

32 MD DirectX 9.0c compatible video card

pedals

artifically generated hardware

hydraulic control systems

What software is needed for the Simulation?
The software needed for a flight simulation includes:

Controls e.g. joysticks

Buttons

If available Simpits

visual pilots

flight simulator software

Where do you think this type of Simulation might go in the future?
i think it can still go further as everything because we are learning more everyday so i believe it can be possible for a flight simulator to get better, exactly like real life enconters.

#3 Forward and Backward Chaining

Backward Chaining

Backward chaining is one of the two methods of reasoning when using inference rules.

x+5=7

x=2

=D

Forward Chaining

Forward chaining is one of the two main methods of reasoning when using inference rules (in artificial intelligence). It is referred in philosophical circle as modus ponens.

 

1.  If X croaks and eats flies – Then X is a frog
2. If X chirps and sings – Then X is a canary
3. If X is a frog – Then X is green
4. If X is a canary – Then X is yellow

lawrence did his sweet and simple.

najib was detailed and showed his knowledge on the topic.

#2 Turing Test

 What is the Turing Test?
The Turing Test is a test that is given to a machine to test its intelligence, it is done using questions, that determines a machine intelligence, or AI capable.

Is the Turing Test a valid test of intelligence?
for a machine to past the test it must have good language, have reason and show knowledge about the question. this will show how intelligent machines can be but they will never be as smart as humans.i think that it can prove that machines are smart but they can never become functioning to make decisions.

5 Questions designed to apply the Turing Test.

• What languages do you speak?
• Where are you from?
• what gender are you?
• How old are you?
• What is the Turing Test?

Can you find a ChatBot that passes the Turing Test? Find a ChatBot on the internet. Have a conversation, screen dump the conversation and add it to your blog.

 

 

  

Evaluate the ChatBot based on it’s responses to your questions. Does it pass the Turing Test?
This ChatBot can reply to simple statements and questions asked. it can answer all the questions above with confidence. also when asked about the turing test it gives a very detailed explanation. So I would say that yes, it has passed the test

Read at least 2 other students’ blogs and comment on their questions and ChatBot conversations.
i agree with lawrence when he says “Sure this test shows if the machine has intelligence but it only imitates a human being”.

i say to najib that smarterchild is a stupid msn and no where near anything as smart as the other chatbots.

#1 AI

what is AI? AI is short for Artificial Intelligence and is the intelligence of machines.

Is AI achievable? so far it has not been done as no robot has been created to be as smart as humans, but as technology progresses it could be something of the near future.

How has AI been represented in film? films that have represented AI would be Transformers and I Robot.

Which film do you think has represented AI in the most plausible way? i think that Transformers because there are a series of machines which have the intelligence of a human or even greater.

Read atleast 2 other students’ blogs and comment on their thoughts. i agree with najib when he says that AI has not been achieved but will be in the future.

i disagree with lawrence i believe that AI will be achievable.

EXERCISE 9.8

2. Begin

          Get slice of bread

          Get butter

          Open butter

          Get knife

          Get butter on knife

          Use knife to put butter on bread

          Wash knife

          Close butter

          Put butter away

          Put knife away

          Eat buttered bread

End

EXERCISE 9.6

1 

1. Plug the microwave into the power.
2. Open microwave door.
3. Place the food into the microwave.
4. Close microwave door.
5. Select time.
6. Press ‘Start’.
7. Remove food when timer rings.

2. ‘Walk to the table where the telephone is sitting, when it rings, and pick up the speaker to speak to the person on the other line.’

3. Inputs: Cake mixture
Processing: Turning on the oven, waiting until the cake has been baked.
Outputs: Cake done YUM!!

EXERCISE 9.5

1. Checkbox – Select multiple options in a form.
Radio Button - Select 1 option from a form.
Page Up/Down - Go to the bottom or top of the page.
Scroll Up/Down - Scroll up or down at about 3 paces.
Text - Add text in a certain area in your form.
Picture - Add an image to your form.
Tools - Change the settings of your form.

2. GUI or a graphical user interface is a user friendly environment which is simple and easy to use for novice or beginning programmers. This type of programming allows beginners to place objects into their forms such as buttons, text, boxes and data. They also allow the use of a wide range of data types. The smallest type of meaningful data used in any program is a character. Numeric data may be either integers or real numbers, also called decimals. Any series of characters is known as a string with special use of variables called the boolean data type used to hold only 2 possible outputs, such as Yes or No.

3.

Data to be handled	Unique Identifier	Data type
Your first name	FirstName	String
Number of students	No.Students	Integer
Your birthday	DOB	Date
Test results	Results	Real Number
Your gender	Sex	Boolean