Question: Map the human processor model and all its parts (Components) that come into play, on above scenario.

Question:

Map the human processor model and all its parts (Components) that come into play, on above scenario.

Task#1 [Marks: 5]: Draw an Entity Relationship Diagram (ER Model) for the given case study along with proper associations and cardinalities.

Task#1 [Marks: 5]:  Draw an Entity Relationship Diagram (ER Model) for the given case study along with proper associations and cardinalities.

Solution:

                        First we write the entities that are involved in this case study.

·         Passenger

·         Booking office

·         Fair

·         Route

·         Flight

·         Airline

·         Airplane

·         Airport

The Diagram is as under. . . .

Task#2 [Marks 5]:

Derive the tables from the ER model and normalize up to third normal form (3^rd NF)

Solution:

Detail Table

Flight ID	Airport code	Airport	Date	Departure	Arrival	Passenger id	Name	Contact
XYZ123	DUB	Dublin	01/11	09:15	09:45	C3458	SMITH	909090
XYZ123	DUB	Dublin	01/11	09:15	09:45	C8765	JONES	919191
XYZ123	DUB	Dublin	01/11	09:15	09:45	C1383	GREEN	909190

1NF

FLIGHT (FlightID, AirportCode, Airport, Date, Departure, Arrival)

FLIGHT-PASSENGER (FlightID,PassengerID, Name, Contact)

2NF

FLIGHT (FlightID, AirportCode, Airport, Date, Departure, Arrical)

FLIGHT_PASSENGER (FlightID, PassengerID)

Passenger (PassengerID, Name, Contact)

3NF

FLIGHT (FlightID, AirportCode, Date, Departure, Arrival)

AIRPORT (AirportCode, Airport)

FLIGHT-PASSENGER (FlightID, PassengerID)

PASSENGER (PassengerID, Name, Contact)

Task#3 [Marks 10]:

De-normalize the database (obtained after completing task#2) by using the “collapsing tables” technique.

How to access the YouTube, Blocked websites.

This tutorial is about how to access the YouTube and all other blocked website.
First of all open your web browser and type Ultrasafe and search. Now from any search link download this software and install it on your computer.
When the installation process complete then a box will appear on your computer screen, minimize it and now you can open all the blocked websites .
If you don't Understand then see this video tutorial.

How to register the Camtasia studio 8 , Free Registration

This tutorial is about How to Register the Camtasia Studio 8 (New Version).
First of all Download the camtasia studio (any version which you found best). You can download Camtasia studio from this link. 
http://www.techsmith.com/download/camtasia/default.asp

Click on this link A new browser page is open
Here you can add your Own email address and clik START WINDOWS DOWNLOAD then your downloading will start.
When the downloading is complete double click that file and installation will start. when during the installation it require a Name and Key.


1.  Name:RedMatriX

    Key:C2CCW-AMCC2-C7CCC-4KFNG-4R4D5



2.  G4DCD-9CC5J-JTDPC-FQJ9X-X735A

3.  GCABC-CPCCE-BPMMB-XAJXP-S8F6R

4.  EA5AC-CLMAM-A8W6W-EZLYM-LM58F

5.  HLCZF-HDCPL-KGB6W-ZSCAZ-VF6A2

6.  CD2AA-QZBHD-C3KJL-E9HRV-Q797C

7.  ABHKC-9YZZB-55MCB-5A4C7-S5868


8.  Name: Your Name                    
    Key: ACRCA-53DCD-H89V8-888EL-7MCCA

I WIll Recommend You Installing With First Key :)

Enjoy ...

Uploaded By- Naeem.

Use Camtasia to . . . . 

1. Record your screen to capture Powerpoint slides , Software demos, Webpages and more.
2. You can make video tutorials from this.
3. Edit your screen recordings and camera video by cutting , splicing and combining clips wit the powerful , yet easy to use, video editor.
4. Import camera video , Music , Photos, and more to truly enhance your screen recordings 
5. Customize your screen recording and video with ready to use media themes, animated background, graphics, callouts, and more.
6. Create interactive videos with clickable links , table of contents , search, and more.
7. Easily share videos that your viewers can watch anywhere , on nearly any device.

How to manage rows and columns in Excel 2012

This video tutorial is about managing the row and columns in excel 2012.

ISHQE NABI DAY ANDER Nusrat fateh ali khan's best qawali

This Qawali is the best qawali of Nusrat Fateh Ali khan. Ishqe Nabi Day Andar.

Sex skandle on mazar-e-Quid

How to access blocked websites.

If you having some trouble to accessing any type of website, then this tutorial will help you a lot.
First Step.
Install HOT SPOT SHIELD
Simply click this link and then clink on the DOWNLOAD when the page loads.
http://www.anchorfree.com/hotspot-shield-VPN-download-windows.php

when the downloading is complete then double click on it.
After that the process of installation will be start, click on the next or simply follow the steps.
After installation just click on the hotspot shield icon on the desktop and click to CONNECT.
when it shows the word PROTECTED then you safely browsing.
You can open any type of wevsite.
Enjoy...........
Thanks.

How to download a full movie in urdu

This tutorial enable you to download a full movie, softwares, books, songs, dramas, and much more from internet.

Flowers that blossoms always in the name of ALLAH.

Beautiful flowers that blossom in the name of ALLAH.

How to download a full movie

This video tutorial is about to downloading movies, softwares, books, applications and many more.