3rd Bachelor in Industrial sciences (1st cycle-Industrial Engineers) Electrical engineering
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.