Database Management Systems PDF

Database Management Systems Chapter: 01 – Part 1 Introduction to DBMS Assoc.Prof. Mohamed Abdelsalam Course Outline  CH.(1): Introduction to DBMS  CH.(2): Relational Model  CH.(3): Entity Relationship Modeling  CH.(4): Enhanced Entity Relationship Modeling  CH.(5)...

Database Management Systems Chapter: 01 – Part 1 Introduction to DBMS Assoc.Prof. Mohamed Abdelsalam Course Outline  CH.(1): Introduction to DBMS  CH.(2): Relational Model  CH.(3): Entity Relationship Modeling  CH.(4): Enhanced Entity Relationship Modeling  CH.(5): Relational Database design (Mapping)  CH.(6): SQL Basics Chapter Outline  Ch. (1) : Introduction to DBMS  Understanding the concept of Data & Information  Explain the difference between Data & Information.  Identify the concept of Database  Identify the concept of DBMS  Disadvantages of file-processing system  Characteristics and Benefits of a Database  What the meaning of Data Abstraction Concept of Data Data is a raw fact and can take the form of a number of statement. Data of student : Name , Age , Level, Gender Data of Course : Title , Cost , Hours, Type Type of data : Number , string , text file , audio, video Concept of Information Information is data that has been converted into meaningful and useful context for end users. (processed data). List of students is information List of male students is information Numbers of optional courses is information Difference between Data & Information  Example: Salesdata is names, quantities and dollar amounts Sales information is amount of sales by product type, or by salesperson How to store data ? Unstructured Data Semi-structured Data Structured Data Case Study If you want to design database to store all data related to student and his/her enrollment courses, grades, and doctors who taught these courses. What can you do ?  Your Solution Dep- Departm Doctor St_No st_name street city phone course_name course desc Grade Doctor phone code ent name name ERP-SAP 12 Haram 33868420 / 101 Hassan Ali Giza 1 BIS ERP Functional 59 Ahmed 01076432566 st. 0111111253 Consultant Java Mobile 12 Haram 33868420 / Application 101 Hassan Ali Giza 1 BIS Java 70 Mai 01088992567 st. 0111111253 s Developers 12 Haram 33868420 / Cyber 101 Hassan Ali Giza 1 BIS CS 60 Sally 01265892234 st. 0111111253 Security Fundement 43 shady 28345655 / al of 102 aboelfeda Giza 2 FMI ACC 88 Ashraf 01134567893 Ayman 0106774544 Financial st. Accounting 43 ERP-SAP shady 28345655 / 102 aboelfeda Giza 2 FMI ERP Functional 89 Ahmed 01076432570 Ayman 0106774544 st. Consultant  The appropriate Solution is Student Student_Tel Department St_No phone St_No st_name street city Dep_code Dep_code Dep_name 101 33868420 101 111111253 101 Hassan Ali 12 Haram st. Giza 1 1 BIS 102 28345655 shady 2 FMI 102 106774544 102 43 aboelfeda st. Giza 2 Ayman courses Student_grades course- Course doctors Description course code Name St_No doc code Grade doc-code doc Name doc phone code ERP-SAP Functional 1 ERP 101 1 1 59 Consultant 1 Ahmed 01076432566 Java Mobile 101 2 2 70 2 Java Applications 2 Mai 01088992567 Developers 101 3 3 60 3 Sally 01265892234 102 4 4 88 3 CS Cyber Security 4 Ashraf 01134567893 102 1 1 89 Fundamental of 4 ACC Financial Accounting