Database Design - KNU

Database Design KNU-ppt Download

  • Date:05 Oct 2020
  • Views:1
  • Downloads:0
  • Size:68.50 KB

Share Presentation : Database Design KNU

Download and Preview : Database Design KNU

Report CopyRight/DMCA Form For : Database Design KNU


Transcription:

Database DesignCourse Overview Course IntroductionA database is an organized collection of related data In modernorganizations databases are used to support day to day.
operations such as personnel management inventory control and customer tracking For instance organizations such aslibraries use database to keep track of their holdings and patroninformation while analyzing circulation data and customer profileto assess consumer demands and service quality .
To provide instruction in both fundamental database principlesand user centric methodologies for effective creation of adatabase system this course will focus on applications of basicdatabase theories in the stand alone environment of MS Access Database Design 2.
Course Objectives Basic database concepts and theories Basic data modeling principles Practice Database design.
Database implementation skills Understand How to build database systemsDatabase Design 3 Course Requirements.
Prerequisites Basic computer skills Technical background is not required Grading Homework Assignments 30 .
Midterm Project 20 Final Project 50 Participation Extra Credit Database Design 4 Course Requirements Grading.
Homework Assignments 30 DB Design DB Implementation Extension of lab exercises do the lab first Midterm Project 20 DB specification consisting of.
database objectives business rules E R diagram DB Specification Template Final Project 50 MS Access implementation of the DB specification Sample Project.
Participation Extra Credit e g Class interactions course feedback etc Database Design 5 Course Policy This class advocates an open book policy of allowing students.
to consult textbooks Internet resources and classmates whenworking on assignments to facilitate learning and promotecollaboration The Honor Code is in effect With the open book policy it isespecially important to clearly indicate in submitted work any.
materials used from other sources Full citation informationshould be given for such sources Students are expected to be active participant in classdiscussions where they will ask questions provide insights and explore ideas .
Database Design 6 Course Resources Required Readings Lecture material and online contents Supplemental Readings.
Access 2013 The Missing Manualby Matthew MacDonald 2013 Pogue Press Databases Demystified 2nd Edition by Andrew Oppel March 2010 McGraw Hill Database Systems Design Implementation and Management 12th Edition .
by Carlos Coronel Steven A Morris Peter Rob 2016 Cengage Learning Course Website http widit2 knu ac kr kiyang t... Database Design 7 Course Resources Course Website.
Syllabus Description Prerequisite Policy Grading Textbooks Schedule Lecture Lab Assignments Assignments.
Description Readings Projects Description Requirements Evaluation Past Current Projects Resources Access Tutorials Resources DB Resources Web DB Resources.
Roster Student Roster log in required Attendance Gradebook from Schedule page Attendance record Assignment grades log in required Database Design 8.
“Database Demystified” is an easy-to-follow book that covers basic database theory, MS Access and SQL at an introductory level. “Database System: Design, Implementation, and Management” is a proper database theory textbook that contains an in-depth description of database theory.

Related Presentations

PowerPoint chep knu ac kr

CHEP as an AMS Regional Center G. N. Kim, J. W. Shin, N. Tasneem, M. W. Lee, D. Son (Center for High Energy Physics, KNU) H. Park (Supercomputing Center, KISTI)

2 Views0 Downloads

Database Models Flat Files and the Relational Database

Database Models: Flat Files and the Relational Database Objectives: Understand the fundamental structure of the relational database model Learn the circumstances under which it is a better choice than the flat file

31 Views0 Downloads

Database Security with focus on Hyperion Database

Hyperion application security determines user access to products using the concept of roles. A role is a set of permissions that determines user access to product functions. User directories store information about the users who can access Hyperion products. Both the Authentication and the authorization processes utilize user information.

26 Views0 Downloads

Chapter 7 amp 8 Logical amp Physical Database Design Methodology

Definition Design methodology Structured design approach using procedures, techniques, tools and documentation aids Conceptual database design Constructing an information model, independent from all physical consideration for an enterprise Logical database design Building an organization database based on a specific data model Physical database ...

37 Views0 Downloads

Physical Database Design

Physical database design The physical database design is tailored to a specific DBMS. There is feedback between physical and logical design, because decisions taken during physical design for improving performance may affect the logical data model. Physical database design steps Translate global logical data model for target DBMS 2.

45 Views0 Downloads

logical design for relational database The Tilly

Logical design. Logical data modeling. Logical data modeling is the process of representing _____and organization in a graphical way without any regard to the physical implementation or the database management system technology involved in storing the data. A logical data model provides all the information about the various entities and the ...

36 Views0 Downloads

Chapter 7 Relational Database Design

– the ability to modify the physical schema without changing the logical schema Applications depend on the logical schema In general, the interfaces between the various levels and components should be well defined so that changes in some parts do not seriously influence others.

28 Views0 Downloads

Database systems design SUNY Oswego

Comparison of Logical and Physical Database Design. Sources of information for physical design process includes global logical data model and documentation that describes model. Conceptual and logical . database design . are . concerned with the . what, physical database design is concerned with the . how.

31 Views0 Downloads

Database systems design Oswego

Logical database design Process of constructing a model of information used in an enterprise based on a specific data model (e.g. relational), but independent of a particular DBMS and other physical considerations.

33 Views0 Downloads

Logical Database Design and the Relational Model

Logical DB design: getting the requirements right >>correctly . transform. the biz logic . for implementation. An E-R data model is not a relational data model need normalization [2nd half of Ch 4] ERD is developed for the purpose of . understanding. biz rules, not structuring data for sound DB . processing. The last part is the goal of logical ...

28 Views0 Downloads

Database Systems Design Implementation and Management

The University Lab: Conceptual Design Verification, Logical Design, and Implementation Hachim Haddouti In this chapter, you will learn: How the Lab Management System modules are defined and refined How attributes and domains are identified and defined for each of the entities defined in the initial E-R model How the database transactions are identified and defined within the system modules ...

27 Views0 Downloads

Database Application Design

Operators: AND, NOT, OR, parentheses Exercise D1 = “computer information retrieval” D2 = “computer retrieval” D3 = “information” D4 = “computer information” Q1 = “information retrieval” Q2 = “information ¬computer” Exercise Stop lists 250-300 most common words in English account for 50% or more of a given text.

12 Views0 Downloads