3rd Bachelor in Industrial sciences (1st cycle-Industrial Engineers) Electromechanics
Computer science
< Back
| ECTS Credits | 4 |
|---|---|
| Number of Hours (h/year) | 45 |
| Teaching staff | BOEMER, Laurent CONNIASSELLE, Jean-Pol KUTY, Ludovic STYLIANIDIS, Dimitri |
| Course Unit | Compulsory |
| Term | Quad. 1 and 2 |
| Code | TECH-BING0017/3 |
| Prerequisite | Notions of algorithmics and programming of the structures of control in Java. groupe informatique None. |
|---|---|
| Aims and Objectives | To study the object-oriented programming concepts with the language Java. groupe informatique Use the entity-relationship (ER) model to analyze a given problem and build a conceptual schema. -Build a logical schema using the relational model starting from the conceptual schema developed earlier. -Deploy the relational schema on a relational database (Oracle). - Query the DB with SQL. |
| Description | Arrays and strings - classes and objects - exceptions - inheritance and polymorphisme - GUI applications with swing - semantic events - text and binary files - sockets groupe informatique Big picture of RDBMS. -Sifferent views or levels of a DB: external, logical, physical. -ER model and relational model. -SQL (data definition language DDL and data manipulation language DML). - Transactions. -Components of an Oracle DBMS. |
| Bibliography | Horton, Maîtrisez Java 2, Wrox Press 2000Horstmann & Cornell, Au coeur de Java 2 : Volume 1, CampusPress 1999Flanagan, Java in a Nutshell, O'Reilly 2002 groupe informatique Pierre Delmal, SQL2 - SQL3, applications à Oracle, De Boeck, 3rd edition, 2001. -Batini, Ceri, Navathe, Conceptual Database Design, Addison-Wesley, 1st edition, 1991. -Jim Melton et Alan R. Simon, SQL: 1999 - Understanding Relational Language Components, Morgan Kaufmann, 2nd edition, 2001. |
| Teaching and Learning Methods | Lectures Laboratory work |
| Assessment Methods | Oral examinations Continuous assessment |
| Notes | Yes |
| Language | French |
The information contained herein is intended for informational purposes only. The Higher Education Institution disclaims any responsibility with regard to its content.