1 / 16

DBST 651

DBST 651. RELATIONAL DATABASE SYSTEMS. DBST 651. The basic slides for this course were provided by the publisher. Acknowledgement to McGraw-Hill.

dafydd
Download Presentation

DBST 651

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. DBST 651 RELATIONAL DATABASE SYSTEMS

  2. DBST 651 • The basic slides for this course were provided by the publisher. Acknowledgement to McGraw-Hill. • These slides have been customized by Dr. Lorina Negreanu , Dr. Mary Hoferek and your instructor. Appreciation is expressed to all who have been involved in the customization process.

  3. DBST 651 DBST 651 Session 1 part 1 of 3.

  4. Welcome! Before viewing this section of the lecture, please download a copy of the syllabus

  5. Key points • Basic database course • does not have prerequisites • it is designed for students with little or no background in database technology • Books - order online • Grades - midterm, final, research, lab, participation

  6. Key points • Online lab help • look at Database Lab under “Course Content”, designed to help you be successful with the lab requirements • most of you will be using the Nova server that has Oracle on it • there are web pages that will show you how to set up an account, how to edit, run scripts on Nova, master the exercises in the workbook

  7. Key points • Course - organized by chapters in Mannino and lab assignments

  8. Key points • Lab - ERD, DDL, populate, view, retrieve data • this course does have a lab where you’ll be working with Oracle • before working with Oracle, you’re going to use ER Assistant which is the data modeling tool that came with your textbook, and developing Entity Relationship Diagram - ERD

  9. Key points • Lab • ERD is basically graphical way of presenting the database that’s going to be developed • once you design the ERD you’re going to translate that into DDL - data definition language, so you’ll be going from the graphical representation to actually defining tables and columns

  10. Key points • Lab • once you have run the DDL you have database structures out there that you can then put data into or you can populate the tables; you can also create views, and then you’ll be able to retrieve the data that you have placed into the tables - that is the fundamental level of database design and development

  11. Key points • Lab - in addition, level 2 - for all 25 points • there may be some additional assignments, that are called level 2 that will be needed for all 25 points associated with the lab exercise

  12. Clarify Oracle In order to do the lab work you’ll need to have access to Oracle database engine. Possible options are: • Nova - • the UMUC server that we will like most of you to use • you can just telnet Nova, set up your account, and then you’ll be set for the semester

  13. Clarify Oracle • Own PC-OAI • if you cannot use Nova, let’s say for example that you’re in Europe or Asia you may have a hard time maintaining your connection to Nova, in that case you may be able to get a copy of the engine on your PC - please look on the Lab Database and follow the steps shown there

  14. Clarify Oracle • At work • in addition, if you can’t get Nova you may have access to an Oracle engine at work, and you’re welcome to use that as well • Own PC-Technet • you can also use a Technet capability; there are directions for that as well on the Database Lab web site

  15. Clarify Oracle • UMUC sites • or you can just go to one of the UMUC labs; for example at Shady Grove, there is a lab on second floor on building one, at College Park there is an open database lab

  16. Clarify Oracle My preference for you be to work on Nova, being able to work from home, and telnet it onto a server, so please give that a try before you try any other options!

More Related