Data+Modeling

=Data Modeling I= Sunday, October 23, 2011 <>

**Topic overview:**
Data Modeling is the process of precisely describing the data requirements for an information system (or set of information systems) and how the different data elements interact with each other. In class today we will look at one of the most common data modeling techniques - Entity-Relationship Diagrams (ERD's).

By the end of today's class you should be able to:
 * Explain the difference between an //Entity//, an //Attribute//, and a //Relationship// in an Entity-Relationship Model
 * Model basic data entities in an organization, assign attributes to those entities, and identify basic relationships between entities using Entity-Relationship Diagrams (ERD's)

**Preparation for class:** In the next two classes we will cover chapter 3 of the book:


 * Jeffrey Hoffer, Mary Prescott, Heikki Topi, Modern Database Management, 9th edition, Pearson Prentice-Hall, 2009, ISBN: 0-13-600391-5.

This reading is available on digital reserve through Blackboard.

For today's class, you need to read pages 89 - 110. The first section on identifying and defining Business Rules and Data Definitions provides good background a solid foundation for the ER-modeling section. We will spend most of our time in class, however, working directly E-R modeling so you should probably focus your attention on the section on E-R Modeling, pages 97-110.

Reference materials:
Slides:

**Pre-class exercise:** Identify one data Entity for the Karwa system that you described for assignment #2 and 3-5 attributes of that entity.

[Bob Monroe] Entity: Driver Attributes: QatarID, First Name, Last Name, Nationality, HireDate

[Haya Al-Mannai] Entity: Customer Attributes: user name, password, city name, street name, house number.

[Najla Al-Madhadi] Entity: Dispatcher Attributes: QatarID, first name, last name, nationality, hiredate

[Fatima Abdulla]: Entity: Application developer. Attributes: EmployeeID, First name, Last name, Hire date.

[Fatima Al-Khayat]: Entity: Customer Attribute: CustomerID, First Name, Last Name, Phone Number, House Address.

[Mohammed Kamal]: Entity: System Administrator Attribute: EmployeeyID, First name, Last name, Phone Number, HireDate.

[Maryam Al-Thani] Entity: Software engineer Attributes: Employee ID, Qatar ID, First Name, Last Name, Nationality, Phone Number and Hire date.

[Al-Jawhra Al-Mana]: Entity: Karwa's driver Attributes: Employee Number, First Name, Last Name, Hire Date, Birth Date

[Maryam Al-Subaie] Entity: Passenger/Customer Attribute: First Name, Last Name, Contact Number, Pick-up and Drop-off Addresses

[Ayah Abujarbou] Entity: Customer. Attribute: First Name, Last Name, Current Address, Desired Location, Frequent used locations, Contact Number.

[Amal Osman] Entity: dispatchers Attribute: First name, Last name, Nationality, years of experience, contact number

[Aisha Al-Zaman] Entity: Application user Attribute: first name, last name, account username, mobile number

[Walied El Hag Ali] Entity: Software developer Attributes: Employee ID, Nationality, First Name, Last Name, Number of years worked in Karwa

[Anas Ali Chaudry] Entity: Owners Attributes: First name, Last name, Bank account number, Number of hired employees, Contact information

[Nasser Al-Khori] Entity: Customer Attributes: First name, Last name, Contact number, Location GPRS coordinates

[Nahan Arif] Entity: iPhone Application user Attributes: First name, Last name, Languages spoken, Location, Phone number

[Dua'a Althabatah] Entity: Google map user Attributes: First name, Last name, Name of the city, Current place information, Languages spoken, Location,

[M Hammad Abbasi] Entity: Customer Attributes: Customer ID, Mobile Number, First name, Last name, Default Address, Preferred Language

[Layal Al-Alami] : Entity: CUSTOMER Attributes: First_Name, Last_Name, Home_Address, Mobile_Number, Nationality

[Abdullrahman Al-Muftah] Entity: Dispatchers Attribute: Dispatcher first and last name, contact information, employee identification, and salary.

[Khadeejah Al-Husseiny] Entity: DISPATCHER Attribute: User_ID, Total_Orders, Total_Driver

[Ahmad Al-Sarraf] Entity: CUSTOMER Attribute: First_Name, Last_Name, Contact Number, Pick-up place, Destination

[Firas Bata] Entity: Driver Attributes: First Name, Last Name, Nationality, Number of Years in Karwa, Phone Number

[Hussain Hejji] Entity: Driver Attribute: First Name, Last Name, Contact Number, Nationality, Area of coverage

[Mohammed Al-Rawahi] Entity: Karwa Information Device Attribute: Maps, destination, customer's name, customers contact number, adress

[Hamsa M Al-Massri] Entity: System Engineer Attribute: First_Name, Last_Name, Phone_Number, Team_Name.

[Sara Al-Mannai] Entity: System developer Attribute: first name, last name, nationality, working period, previous experience

[Hind Al Khulaifi] Entity: Customer Attribute: first name, last name, nationality, Mobile number

[Jevika Shetty] Entity: driver Attribute: First_Name, Last_Name, nationality, User_ID

[Noor Al-Mohannadi] Entity: Customer Attribute: First name, Last name, Phone number.

[Patrick Steinhagen] Entity: driver Attribute: first name, last name, location, National ID, internal reference number

[Nijat Ibrahimov] Entity: Passenger (Customer) Attribute: First Name. Last Name, Location, Spoken Language.

[Meshail Al Misnad]: Entity: customer Attribute: preferred language, location, destination.

[Mohammed Hadi Takiddin]: Entity: Driver. Attribute: First name, last name, National ID number, and the license number associated with license plate number of the car he is driving.

[Dalia Saleh Hassan]: Entity: Customers. Attribute: First name, destination, and the usage of our services frequency.

[Fatima Fikree] entity:customer attribute: name, nationality, phone number

[Mohammed Al Ahmadani]: Entity: driver attribute: first name, last name, Qatari ID number, nationality

[Mughees Ahmed] Entity: Customer Attribute: Name, desirability, status, personal details.

[Orkhan Rustamzade] Entity: Driver Attribute: First Name, Last Name, Nationality, Plate Number, Driving License Number