IT1102 Mathematics for Computing 1

1
FORUM FOR BIT IT 1102 IT 1302
2
PC APPLICATION-Assignment

• 1. Create a suitable MS Access table structure to
  represent above data. Your answer should include
  table names, Field Names, Data types and primary
  keys of each table. (You may attach screen
  printouts of tables in design view suitably
  cropped)

3
PC APPLICATION-Assignment

• 2. Define suitable relationships between the
  tables created in Question 1. (screen print out
  of the relationships window)

4
PC APPLICATION-Assignment

• 3. Assume that valid entries for Sex field is
  M, F and for Rating Field valid entries are
  PG, PG13, and R . How can you ensure that
  only these valid entries can be entered to these
  fields? Explain your answer.

5
PC APPLICATION-Assignment

• 4. As can be seen from the data above there is a
  one- to- many relationship between Movie and
  Invoice. If you change the movie number in movie
  for some reason that change should be reflected
  in Invoice Table. How can this be achieved in MS
  Access?

6
PC APPLICATION-Assignment

• 5. Invoice information needs to be queried by
  Customer Id. How can you speed up this query by
  using a property in Access?

7
PC APPLICATION-Assignment

• 6. What are the different types of queries in MS
  Access?
• Assume there are more than hundred customers
  in this video library and it is often necessary
  to query for invoice information for a customer.
  What is the most suitable query type for this
  purpose?

8
PC APPLICATION-Assignment

• 7. If the Rental Fee for all movie copies needs
  to be increased by 2. What is the suitable query
  type that can be used?

9
PC APPLICATION-Assignment

• 8 What is the advantage of creating Indexes in
  access? If you have many indexes attached to a
  table is it advantageous or not? Explain your
  answer.

10
Question 2

• Create a presentation on the title Introduction
  to Computer Viruses, using MS PowerPoint.

11
Question

• A famous detective was called to solve a murder
  mystery. He determined the following facts.
• a) Mr. Nelson, the murdered man, was killed by a
  blow on the head with a brass candlestick.
• b) Either Mrs. Nelson or a maid, Wimala, was in
  the dining room at the time of the murder.
• c) If the Cook was in the kitchen at the time of
  the murder, then the butler killed Mr. Nelson
  with a fatal dose of cyanide.

12
Question

• d) If Mrs. Nelson was in the dining room at the
  time of the murder, then the Chauffer killed Mr.
  Nelson
• e) If the _________ was not in the kitchen at the
  time of the murder, then Wimala was not in the
  dining room when the murder was committed.
• f) If Wimala was in the dining room at the time
  the murder was committed, then the Wine Steward
  killed Mr. Nelson.

13
Identify the statements

• Mr. Nelson was killed by a blow on the head with
  a brass candlestick p
• Mrs. Nelson was in the dining room at the time of
  the murder q
• Wimala was in the dining room at the time of the
  murder r
• The cook was in the kitchen at the time of the
  murder s

14
Identify the statements

• The Butler killed Mr. Nelson with a dose of
  cyanide t
• The Chauffer killed Mr. Nelson u
• The Wine Steward killed Mr. Nelson v

15
Build the propositions

• p
• q ? r
• s ? t
• q ? u
• r ? v
• ? ? ?r

16
Logical Operators

• OR
• p or q ? p ? q
• p q p ? q
• T T T
• T F T
• F T T
• F F F

17
Logical Operators

• AND
• p and q ? p ? q
• p q p ? q
• T T T
• T F F
• F T F
• F F F

18
Logical Operators

• NOT
• not p ? ?p
• p ?p
• T F
• F T

19
Logical Operators

• Implies
• p implies q ? p ? q ? if p then q
• p q p ? q
• T T T
• T F F
• F T T
• F F T

20
Logical Operators

• p if and only if q
• p iff q ? p ? q ? (p ? q) ? (p ? q)
• p q p ? q
• T T T
• T F F
• F T F
• F F T

21
Solve the problem

• Consider that all propositions are TRUE.
• then,
• p TRUE
• ? t FALSE
• then for s ? t to be TRUE,
• s - FALSE

22
Changes in Computer Systems

• INTRODUCTION TO COMPUTERS (22 ? 06)
• HISTORY OF COMPUTERS (04 ? X)
• WINDOWS/DOS OPERATING SYSTEMS (06 ? 08)

23
Changes in PC Applications

• INTRODUCTION TO PC NETWORKS AND INTERNET (04)
• WORD PROCESSING
• SPREADSHEET APPLICATIONS
• DATABASE APPLICATIONS
• PRESENTATION APPLICATIONS

24
Changes in PC Applications

• CAD/CAM APPLICATIONS X
• COMPUTER VIRUSES

25
New Content

• WEB AUTHORING (08)
• DEVELOPING WEB PAGES USING HTML BASICS AND USE
  WEB AUTHORING TOOLS (FONTPAGE)