TÜRKÇE
ENGLISH
Information
| Unit | FACULTY OF ENGINEERING |
| ELECTRICAL-ELECTRONIC ENGINEERING PR. (ENGLISH) | |
| Code | EEE474 |
| Name | Database Programming for Internet Applications II |
| Term | 2018-2019 Academic Year |
| Semester | 8. Semester |
| Duration (T+A) | 3-2 (T-A) (17 Week) |
| ECTS | 5 ECTS |
| National Credit | 4 National Credit |
| Teaching Language | İngilizce |
| Level | Üniversite Dersi |
| Type | Normal |
| Label | E Elective |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Doç. Dr. TURGAY İBRİKÇİ |
| Course Instructor |
Doç. Dr. TURGAY İBRİKÇİ
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
This course introduces the fundamentals for creating dynamic web page content generated using relational databases. This course is structured around Microsoft Visual Studio.NET and modern object-oriented programming languages like CSharp. Fundamental technologies like ADO.NET database connectivity, ASP.NET active page technology, XML, SOAP, and Web Services are examined.
Course Content
This course covers database design and the use of database management systems for Internet applications. It includes extensive coverage of the relational model, relational algebra, and SQL.
Course Precondition
Resources
Notes
www.w3schools.com Internet sitesi, Dreamviewer ve SQL Server 2008 programı
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Has capability in those fields of mathematics and physics that form the foundations of engineering. | 0 |
| PLO02 | - | Grasps the main knowledge in the basic topics of electrical and electronic engineering. | 0 |
| PLO03 | - | Comprehends the functional integrity of the knowledge gathered in the fields of basic engineering and electrical-electronics engineering. | 4 |
| PLO04 | - | Identifies problems and analyzes the identified problems based on the gathered professional knowledge. | 5 |
| PLO05 | - | Formulates and solves a given theoretical problem using the knowledge of basic engineering. | 1 |
| PLO06 | - | Has aptitude for computer and information technologies | 4 |
| PLO07 | - | Knows English at a level adequate to comprehend the main points of a scientific text, either general or about his profession, written in English. | 4 |
| PLO08 | - | Has the ability to apply the knowledge of electrical-electronic engineering to profession-specific tools and devices. | 3 |
| PLO09 | - | Has the ability to write a computer code towards a specific purpose using a familiar programming language. | 5 |
| PLO10 | - | Has the ability to work either through a purpose oriented program or in union within a group where responsibilities are shared. | 4 |
| PLO11 | - | Has the aptitude to identify proper sources of information, reaches them and uses them efficiently. | 4 |
| PLO12 | - | Becomes able to communicate with other people with a proper style and uses an appropriate language. | 3 |
| PLO13 | - | Internalizes the ethical values prescribed by his profession in particular and by the professional life in general. | 0 |
| PLO14 | - | Has consciousness about the scientific, social, historical, economical and political facts of the society, world and age lived in. | 0 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Meeting, What XHTML is, Creating and Running a Stored Procedure | Read the chapter on the subject | |
| 2 | Running a Simple Stored Procedure from CSharp Code | Read the chapter on the subject | |
| 3 | Data requirements and conceptual model | Read the chapter on the subject | |
| 4 | SQL queries over the database | Read the chapter on the subject | |
| 5 | Introducing CSharp header files for the database | Read the chapter on the subject | |
| 6 | Working on Simple Classes and the classes for the database | Read the chapter on the subject | |
| 7 | Fundamentals and syntax of the SQL language | Read the chapter on the subject | |
| 8 | Midterm | It covers all previous topics in this course | |
| 9 | select and distinct statements of SQL | Read the chapter on the subject | |
| 10 | Insert, Update and delete statements of SQL | Read the chapter on the subject | |
| 11 | Create statement of SQL | Read the chapter on the subject | |
| 12 | SQL functions | Read the chapter on the subject | |
| 13 | Primary and Foreign keys | Read the chapter on the subject | |
| 14 | Create tables using SQL statements on the cross-examination | Read the chapter on the subject | |
| 15 | XHTML, CSS, and SQL in a Web page using the advanced design | Read the chapter on the subject | |
| 16 | Final Exam | it covers all topics of the course | |
| 17 | Final Exam | it covers all topics of the course |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |