TÜRKÇE
ENGLISH
Information
| Unit | FACULTY OF ENGINEERING |
| ELECTRICAL-ELECTRONIC ENGINEERING PR. (ENGLISH) | |
| Code | EEE474 |
| Name | Database Programming for Internet Applications II |
| Term | 2019-2020 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 |
|---|---|
| LO01 | It will enable the database to understand what it is and to create a database. |
| LO02 | Create database with SQL, add, delete, update and edit records. |
| LO03 | They prepare an Internet page with visual elements that can interact with the database. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied knowledge in these areas in complex engineering problems. | 0 |
| PLO02 | - | Ability to identify, formulate, and solve complex engineering problems; ability to select and apply proper analysis and modeling methods for this purpose. | 0 |
| PLO03 | - | Ability to design a complex system, process, device or product under realistic constraints and conditions, in such a way as to meet the desired result; ability to apply modern design methods for this purpose. | 4 |
| PLO04 | - | Ability to devise, select, and use modern techniques and tools needed for analyzing and solving complex problems encountered in engineering practice; ability to employ computer programming techniques, and information technologies effectively. | 5 |
| PLO05 | - | Ability to design and conduct experiments, gather data, analyze and interpret results for investigating complex engineering problems or discipline specific research questions. | 1 |
| PLO06 | - | Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually. | 4 |
| PLO07 | - | Ability to communicate effectively, both orally and in writing; knowledge of a minimum of one foreign language; ability to write effective reports and comprehend written reports, prepare design and production reports, make effective presentations, | 4 |
| PLO08 | - | Recognition of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself. | 3 |
| PLO09 | - | Consciousness to behave according to ethical principles and professional and ethical responsibility; knowledge on standards used in engineering practice. | 5 |
| PLO10 | - | Knowledge about business life practices such as project management, risk management, and change management; awareness in entrepreneurship, innovation; knowledge about sustainable development. | 4 |
| PLO11 | - | Knowledge about the global and social effects of engineering practices on health, environment, and safety, and contemporary issues of the century reflected into the field of engineering; awareness of the legal consequences of engineering solutions. | 4 |
| PLO12 | - | Ability to apply the knowledge of electrical-electronics engineering to profession-specific tools and devices. | 3 |
| PLO13 | - | Having 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 | Mid-Term Exam | 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 | Term Exams | it covers all topics of the course | |
| 17 | Term Exams | it covers all topics of the course |
Assessment (Exam) Methods and Criteria
Current term shares have not yet been determined. Shares of the previous term are shown.
| 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 |