1 / 13

CT 5705701 Database Systems and Information Technology

CT 5705701 Database Systems and Information Technology. Course Introduction by Hung-Ming Chen. Conceptual Design of Databases (The E-R Model). Relational Model. Table (Relation, Relational Schema). Schema # 1. Schema # 2. : Entity. : Relationship. : attribute.

daria-fleming
Download Presentation

CT 5705701 Database Systems and Information Technology

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CT 5705701 Database Systems and Information Technology Course Introduction by Hung-Ming Chen

  2. Conceptual Design of Databases (The E-R Model)

  3. Relational Model Table (Relation, Relational Schema)

  4. Schema # 1

  5. Schema # 2

  6. : Entity : Relationship : attribute The E-R Diagram for Schema #2 sid name class cid instructor grade Enrolled Students Courses

  7. Creating Relations Using SQL (DDL) CREATE TABLE Students ( sid CHAR(20), name CHAR(30), login CHAR(20), age INTEGER, gpa REAL )

  8. Modifying Relations (DML) INSERT INTO Students(sid, name, login, age, gpa) VALUES(53688, ‘Smith’, ‘smith@ee’, 18, 3.2) DELETE FROM Students S WHERE S.name = ‘Smith’

  9. SQL Queries (DQL) Find the name of all students who enrolled in the course numbered by ‘CT5705’. SELECT S.name FROM Students S, Enrolled E WHERE S.sid = E.sid AND E.cid = ‘CT5705’

  10. Relational Algebra and Calculus Relational Algebra: Relational Calculus:

  11. Schema Refinement and Normal Forms • Schema Refinement: Reduce redundancy by replace a relation schema with several smaller relation schemas. • A normal form is a property of a relation schema indicating the type of redundancy that the relation schema exhibits.

  12. HTML A simple HTML document: <HTML> <HEAD> <TITLE> CT 5705 </TITLE> </HEAD> <BODY> Welcome to <BR> CT5705! </BODY> </HTML>

  13. Scripting Languages • Scripts is a program that can be embedded in an HTML page. • Scripting language can be used to add interactivity to your web page. • JavaScript and VBScript: client-side programs. • ASP: server-side program, can utilize the resources on the server, such as a database to produce more customized effect.

More Related