University :Mansoura University |
Faculty :Faculty of Engineering |
Department :Computers and Systems Engineering |
|
| 1- Course data :- |
| | Code: | 3412ح | | Course title: | Data Processing-1 | | Year/Level: | رابعة | | Program Title: | | | Specialization: | | | Teaching Hours: | Theoretical: | 4 | Tutorial: | 2 | Practical: | |
|
| 2- Course aims :- |
| - This course is undergraduate-level introduction to database systems and applications based on databases. It about the principles of designing and developing applications using the relational database system. Upon successful completion of this course, students will have the skills to analyze business requirements and produce a practical model and implementation of a database
- Familiarizing the student with the concepts, languages, and architectures of database systems.
- Introducing the student to database design and technology.
- Training the student in writing programs in both data definition and data manipulation languages
|
| 3- Course Learning Outcomes :- |
| |
| 4- Course contents :- |
| | No | Topics | Week |
|---|
| 1 | What is A Database? Databases basics and Database Users | | | 2 | Database Types | | | 3 | Database System Concepts and DBMS Architecture | | | 4 | Data modeling, database design theory | | | 5 | Data Modeling Using the Entity-Relationship Model ER- to-Relational Mappings | | | 6 | Normalization for Relational Databases ? The Relational Algebra ? SQL - The Relational Database Standard ? Nested SQL | |
|
|
| 5- Teaching and learning methods :- |
| | S | Method |
|---|
| Lecture | | Lab activities | | Discussion sessions |
|
|
| 6- Teaching and learning methods of disables :- |
| - -None
|
|
| 7- Student assessment :- |
| A. Timing |
| | No | Method | Week |
|---|
| 1 | Weekly Periodical sheets to access understanding of each chapter or terminated job | 1 | | 2 | Lab activities to access implementation of the practical parts | 3 | | 3 | Oral exam to access understanding how to complete job | 6 | | 4 | Mid term Exam to access understanding of the complete course | 8 | | 5 | Final term Exam to access understanding of the complete course | 15 |
|
| B. Degree |
| | No | Method | Degree |
|---|
| 1 | Mid_term examination | 10 | | 2 | Final_term examination | 60 | | 3 | Oral examination | 5 | | 4 | Practical examination | 5 | | 5 | Semester work | 5 | | 6 | Other types of asessment | 5 | | Total | 100% |
|
|
| 8- List of books and references |
| | S | Item | Type |
|---|
| 1 | ? “An Introduction to Database Systems”, C. J. Date, 7th Edition, Addison Wesley, 2006. | |
|
|
| 9- Matrix of knowledge and skills of the course |
| | S | Content | Study week |
|---|
| What is A Database? Databases basics and Database Users | | | Database Types | | | Database System Concepts and DBMS Architecture | | | Data modeling, database design theory | | | Data Modeling Using the Entity-Relationship Model ER- to-Relational Mappings | | | Normalization for Relational Databases ? The Relational Algebra ? SQL - The Relational Database Standard ? Nested SQL | |
|
|
| Course Coordinator(s): - |
| - Hisham Arafat Ali Khalifa
|
| Head of department: - |
| Hisham Arafat Ali Khalifa |
