Database Concept - ERD Mapping to MS Access

Oct 19, 2015Download as pptx, pdf1 like1,680 views

This document provides mappings from Chen's entity-relationship (ER) diagram notations to database tables. It discusses how various ER relationships such as one-to-one, one-to-many, many-to-many, weak entity, and inheritance mappings are represented in tables. Examples are given for each type of relationship such as a one-to-many relationship between a Seller and Purchase or a many-to-many relationship between a Student and the Classes they register for. Notes are included to explain considerations for representing relationships properly in tables.

Oum Saokosal
Master of Engineering in Information System
Jeonju University, South Korea
O12-252-752
Mapping: Chen ERD to Table
Relationship

Notation in Chen's E-R Diagram
 Entity
Note: An Entity in ER is an interested Entity.
 Relationship
 Weak Entity
 Identifying Relationship
Student
Register
Play on

Attribute
 Attribute
(XXX 1 – 1 dob)
 Multi-valued Attribute
(XXX 1 – M tel)
 Composite Attribute
(XXX M – 1 address)
 (XXX 1 – 1 address)
 Multi-valued Composite Attribute
(XXX 1 – M Category)
 Derived Attribute (XXX 1 – 1 age)
dob
tel
address
age
House
Street
category
code
description

Mapping: 1-N
Seller make Purchase
1 N
hire_date
id
name
tel other
id
date
name
Customer
tel
Note: in ER diagram, seller id is not
included in the table Purchase. It is the
foreign key referenced from the table Seller.
However, in the table relationship, seller id
has to be included the table Purchase in
order to make it 1-to-M relationship.

Mapping: M-N
Student Register Class
M N
register date
reg id
tel
id
name
sex address
id
name
year
semester
capacity

Mapping: ISA Relationship
Student
tel
id
name
sex address
isa
Bachelor
Master
PhD
publication
research
thesis
dissertation
Note:
In Student:
st_id: Autonumber
In Bachelor, Master,
PhD:
st_id: Number

Mapping: M-N Tenary
Student Register Class
M N
register date
reg idtelid
name
sex
address
id
name
year
semester
capacity
Cashier
name
tel
T

Mapping: M-1 Unary (1)
Employee
tel
id
name
sex
address
Report to
M
1
Cannot enter 4 in
table em_report_to
because no em_id = 4 yet.

Mapping: M-1 Unary (2)
SELECT S.em_id, S.em_name AS Boss, T.em_id, T.em_name AS Staff
FROM tbl_employee AS S, tbl_employee AS T
WHERE S.em_id = T.em_report_to;

Mapping: M-N Unary
Employee
tel
id
name
sex
address
Report to
M
N

Oum Saokosal
Master of Engineering in Information Systems,
Jeonju University, South Korea
012-252-752
oum_saokosal@yahoo.com
End of Chapter

The document provides information on entity relationship diagrams (ERDs), including the objectives, components, and steps to create an ERD. It defines key ERD concepts like entities, attributes, relationships, and cardinality. It describes the entity modeling process and discusses how to recognize entities, attributes, relationships, and cardinalities in a database. It outlines the general steps to create an ERD, including identifying entities, finding relationships between entities, drawing a rough ERD, defining primary keys, identifying attributes, mapping attributes to entities, and drawing a fully attributed ERD. Sample ERDs are provided to illustrate concepts like cardinality constraints.

10.3 Android VideoOum Saokosal

This document provides instructions for playing a video on an Android device using a VideoView widget. It recommends testing video playback on a real Android device rather than an emulator. It describes adding a VideoView to an XML layout file, finding the VideoView in Java code, setting the video path and media controller, and starting the video playback. The document was authored by Oum Saokosal and includes their contact information.

11.1 Android with HTMLOum Saokosal

Java Programming - PolymorphismOum Saokosal

This document discusses polymorphism and inheritance in object-oriented programming. It begins with defining polymorphism and how it relates to inheritance and class encapsulation. An example is provided to demonstrate how a reference variable can refer to objects from different classes that inherit from the same parent class. The document also discusses specific uses of polymorphism in methods and arrays, as well as notes about overriding and adding new methods. It covers casting objects and using the instanceof operator to check the type before casting. Key concepts of polymorphism, inheritance, overriding, and casting are summarized.

Objected-Oriented Programming with JavaOum Saokosal

This document provides an overview of object-oriented programming concepts in Java, including classes, objects, constructors, and accessing object data and methods. It defines a class as a template for creating objects, with data fields and behaviors like constructors and methods. Constructors are used to construct (create) objects from a class by initializing their data fields. Objects are then accessed by calling their methods, such as a toString() method to return the object's data as a string. The document also notes that Java is a pure object-oriented programming language and many other languages also use OOP.

Java Programming - Introduction to Abstract ClassOum Saokosal

This document discusses abstract classes in Java. It defines an abstract class as a class marked with the abstract keyword that can contain abstract methods without implementations, as well as normal methods. Subclasses must override any abstract methods, ensuring they provide an implementation. The document provides an example of an abstract Shape class with abstract getArea() and getPerimeter() methods. It also discusses how to create abstract classes, use them through inheritance and polymorphism, and their importance in enforcing method implementations in subclasses for polymorphic behavior.

Java Programming - InheritanceOum Saokosal

Inheritance allows classes to inherit properties and methods from existing classes. This allows code reuse and avoids rewriting common functionality. The existing class is called the superclass, while the class inheriting is the subclass. The subclass inherits all non-private fields and methods from the superclass. Inheritance is implemented in Java using the "extends" keyword. The subclass can override methods from the superclass to modify their behavior. All classes in Java implicitly extend the Object class, which defines common methods like equals(), hashCode(), and toString().

09.1. Android - Local Database (Sqlite)Oum Saokosal

This document provides information about SQLite databases in Android applications. It discusses how SQLite is integrated into the Android runtime, demonstrates basic SQL statements for creating tables, inserting, updating, deleting and selecting records, and shows code examples for executing SQL statements and retrieving data using a Cursor object in an Android app. It also explains how to view the database files on an Android emulator.

Database Concept - Normalization (1NF, 2NF, 3NF)Oum Saokosal

The document discusses normalization, which is the process of converting complex data structures into simple structures to avoid data duplication. It describes the three main steps of normalization: first normal form (1NF), second normal form (2NF), and third normal form (3NF). The document provides examples of tables and explains how to normalize them by removing anomalies like repeating groups and partial/transitive dependencies between attributes. While there are several normal forms, 3NF is sufficient for most use cases and removes all transitive dependencies. Functional dependencies, which define relationships between attributes, are also discussed.

Java Programming - Abstract Class and InterfaceOum Saokosal

This document provides an overview of abstract classes and interfaces in Java. It defines what an interface is, how to define and use interfaces, and why interfaces are used instead of abstract classes. Key points include: Interfaces are similar to abstract classes but can only contain abstract methods and constants. Classes implement interfaces to inherit their methods. Abstract classes can contain both abstract and non-abstract methods. Interfaces are used instead of abstract classes to allow for multiple inheritance in Java, since a class can only extend one parent class but implement multiple interfaces. Interfaces define weak "is-a" relationships while abstract classes define strong "is-a" relationships. The UML notation for interfaces uses <<interface>> to differentiate them

Erd practice exercisesJennifer Polack

The document describes two database design exercises. The first involves designing a database to store information about employees, departments, and employee children. It involves entities for employees, departments, and children and relationships indicating employees work in departments, departments have managers, and children can be identified through their parent employee. The second exercise involves designing a database for an art gallery. It involves entities for artists, artworks, groups, and customers. Artworks are created by artists and can belong to multiple groups. Customers like certain artists and groups. The solution diagrams the entities and relationships along with constraints like each artwork is created by one artist.

Database Normalization 1NF, 2NF, 3NF, BCNF, 4NF, 5NFOum Saokosal

Erd examplesPramod Redekar

04 erd & mappingsanshori996

Android - IntroductionOum Saokosal

บทที่ 5 การแปลง er diagram ให้เป็น tableครูสม ฟาร์มมะนาว

10.1. Android AudioOum Saokosal

The document provides instructions for playing audio files in Android using the MediaPlayer class. It explains how to create a MediaPlayer object from a raw audio resource, call methods like start(), pause(), stop() to play, pause and stop the audio, and check the playing status with isPlaying(). It also demonstrates how to setup button clicks to call these methods and release the MediaPlayer when the activity stops.

07.4. Android Basic Simple Browser (WebView)Oum Saokosal

07.3. Android Alert message, List, Dropdown, and Auto CompleteOum Saokosal

04. Review OOP with JavaOum Saokosal

06. Android Basic Widget and ContainerOum Saokosal

This document discusses widgets and containers in Android layouts. It provides examples of common widgets like TextView, ImageView, Button, EditText, CheckBox and DigitalClock. It also demonstrates different container layouts, including LinearLayout, RelativeLayout and TableLayout. Code snippets are given to illustrate how to declare these widgets and containers in an XML layout file named main.xml.

08.1. Android How to Use Intent (explicit)Oum Saokosal

This document discusses intents in Android. It explains that intents are used to invoke activities both internally and externally. An intent can be used to explicitly start a new activity by creating an intent, putting extras like key-value pairs, and calling startActivity. This is demonstrated with code examples of two activities - Activity01 starts Activity02 by creating an intent and passing an ID extra, which Activity02 retrieves using getIntent().getExtras().

Using intents in androidOum Saokosal

This document describes how to use intents in Android. It provides an overview of intents, the difference between implicit and explicit intents, how to transfer data between activities using intents, and how to register an application to respond to implicit intents using intent filters. It includes code examples for starting implicit intents to open URLs, make phone calls, and transfer data between activities using explicit intents.

10.2 Android Audio with SD CardOum Saokosal

This document provides instructions for uploading audio files to the SD card of an Android emulator so they can be played by a media player application being tested. It describes creating an SD card partition for the emulator, using DDMS to push files to the emulator's mnt/sdcard folder, and playing songs from the SD card by specifying their file paths. The document also gives examples of using the MediaPlayer class to play songs from raw resources or the SD card.

07.1. Android Even HandlingOum Saokosal

The document discusses event handling in Android applications. It covers XML-based event handling where events are defined in the XML layout. It also covers Java-based event handling where events are handled by implementing listener interfaces in the Java code. It provides examples of handling click and long click events. It also lists some other event listeners that can be used, such as OnFocusChangeListener, OnKeyListener, OnTouchListener, and OnCreateContextMenuListener.

데이터베이스의 이해Byung Kook Ha

Ajanta Paintings: Study as a Source of HistoryVirag Sontakke

This Presentation is prepared for Graduate Students. A presentation that provides basic information about the topic. Students should seek further information from the recommended books and articles. This presentation is only for students and purely for academic purposes. I took/copied the pictures/maps included in the presentation are from the internet. The presenter is thankful to them and herewith courtesy is given to all. This presentation is only for academic purposes.

How to Clean Your Contacts Using the Deduplication Menu in Odoo 18Celine George

More Related Content

Viewers also liked (20)

Java Programming - InheritanceOum Saokosal

09.1. Android - Local Database (Sqlite)Oum Saokosal

Database Concept - Normalization (1NF, 2NF, 3NF)Oum Saokosal

Java Programming - Abstract Class and InterfaceOum Saokosal

Erd practice exercisesJennifer Polack

Database Normalization 1NF, 2NF, 3NF, BCNF, 4NF, 5NFOum Saokosal

Erd examplesPramod Redekar

04 erd & mappingsanshori996

Android - IntroductionOum Saokosal

บทที่ 5 การแปลง er diagram ให้เป็น tableครูสม ฟาร์มมะนาว

10.1. Android AudioOum Saokosal

07.4. Android Basic Simple Browser (WebView)Oum Saokosal

07.3. Android Alert message, List, Dropdown, and Auto CompleteOum Saokosal

04. Review OOP with JavaOum Saokosal

06. Android Basic Widget and ContainerOum Saokosal

08.1. Android How to Use Intent (explicit)Oum Saokosal

Using intents in androidOum Saokosal

10.2 Android Audio with SD CardOum Saokosal

07.1. Android Even HandlingOum Saokosal

데이터베이스의 이해Byung Kook Ha

Java Programming - InheritanceOum Saokosal

09.1. Android - Local Database (Sqlite)Oum Saokosal

Database Concept - Normalization (1NF, 2NF, 3NF)Oum Saokosal

Java Programming - Abstract Class and InterfaceOum Saokosal

Erd practice exercisesJennifer Polack

Database Normalization 1NF, 2NF, 3NF, BCNF, 4NF, 5NFOum Saokosal

Erd examplesPramod Redekar

04 erd & mappingsanshori996

Android - IntroductionOum Saokosal

บทที่ 5 การแปลง er diagram ให้เป็น tableครูสม ฟาร์มมะนาว

10.1. Android AudioOum Saokosal

07.4. Android Basic Simple Browser (WebView)Oum Saokosal

07.3. Android Alert message, List, Dropdown, and Auto CompleteOum Saokosal

04. Review OOP with JavaOum Saokosal

06. Android Basic Widget and ContainerOum Saokosal

08.1. Android How to Use Intent (explicit)Oum Saokosal

Using intents in androidOum Saokosal

10.2 Android Audio with SD CardOum Saokosal

07.1. Android Even HandlingOum Saokosal

데이터베이스의 이해Byung Kook Ha

Recently uploaded (20)

Ajanta Paintings: Study as a Source of HistoryVirag Sontakke

How to Clean Your Contacts Using the Deduplication Menu in Odoo 18Celine George

Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...Leonel Morgado

antiquity of writing in ancient India- literary & archaeological evidencePrachiSontakke5

Cultivation Practice of Turmeric in Nepal.pptxUmeshTimilsina1

The History of Kashmir Karkota Dynasty NEP.pptxArya Mahila P. G. College, Banaras Hindu University, Varanasi, India.

This slide is an exercise for the inquisitive students preparing for the competitive examinations of the undergraduate and postgraduate students. An attempt is being made to present the slide keeping in mind the New Education Policy (NEP). An attempt has been made to give the references of the facts at the end of the slide. If new facts are discovered in the near future, this slide will be revised. This presentation is related to the brief History of Kashmir (Part-I) with special reference to Karkota Dynasty. In the seventh century a person named Durlabhvardhan founded the Karkot dynasty in Kashmir. He was a functionary of Baladitya, the last king of the Gonanda dynasty. This dynasty ruled Kashmir before the Karkot dynasty. He was a powerful king. Huansang tells us that in his time Taxila, Singhpur, Ursha, Punch and Rajputana were parts of the Kashmir state.

Drugs in Anaesthesia and Intensive Care,.pdfcrewot855

How to Configure Public Holidays & Mandatory Days in Odoo 18Celine George

Ancient Stone Sculptures of India: As a Source of Indian HistoryVirag Sontakke

Myasthenia gravis (Neuromuscular disorder)Mohamed Rizk Khodair

U3 ANTITUBERCULAR DRUGS Pharmacology 3.pptxMayuri Chavan

Origin of Brahmi script: A breaking down of various theoriesPrachiSontakke5

TERMINOLOGIES,GRIEF PROCESS AND LOSS AMD ITS TYPES .pptxPoojaSen20

History Of The Monastery Of Mor Gabriel Philoxenos Yuhanon Dolabanifruinkamel7m

How to Create Kanban View in Odoo 18 - Odoo SlidesCeline George

How to Share Accounts Between Companies in Odoo 18Celine George

Transform tomorrow: Master benefits analysis with Gen AI today webinar, 30 A...Association for Project Management

Transform tomorrow: Master benefits analysis with Gen AI today webinar Wednesday 30 April 2025 Joint webinar from APM AI and Data Analytics Interest Network and APM Benefits and Value Interest Network Presenter: Rami Deen Content description: We stepped into the future of benefits modelling and benefits analysis with this webinar on Generative AI (Gen AI), presented on Wednesday 30 April. Designed for all roles responsible in value creation be they benefits managers, business analysts and transformation consultants. This session revealed how Gen AI can revolutionise the way you identify, quantify, model, and realised benefits from investments. We started by discussing the key challenges in benefits analysis, such as inaccurate identification, ineffective quantification, poor modelling, and difficulties in realisation. Learnt how Gen AI can help mitigate these challenges, ensuring more robust and effective benefits analysis. We explored current applications and future possibilities, providing attendees with practical insights and actionable recommendations from industry experts. This webinar provided valuable insights and practical knowledge on leveraging Gen AI to enhance benefits analysis and modelling, staying ahead in the rapidly evolving field of business transformation.

APGAR SCORE BY sweety Tamanna Mahapatra MSc PediatricSweetytamannaMohapat

How to Manage Upselling in Odoo 18 SalesCeline George

spinal cord disorders (Myelopathies and radiculoapthies)Mohamed Rizk Khodair

Ajanta Paintings: Study as a Source of HistoryVirag Sontakke

How to Clean Your Contacts Using the Deduplication Menu in Odoo 18Celine George

Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...Leonel Morgado

antiquity of writing in ancient India- literary & archaeological evidencePrachiSontakke5

Cultivation Practice of Turmeric in Nepal.pptxUmeshTimilsina1

The History of Kashmir Karkota Dynasty NEP.pptxArya Mahila P. G. College, Banaras Hindu University, Varanasi, India.

Drugs in Anaesthesia and Intensive Care,.pdfcrewot855

How to Configure Public Holidays & Mandatory Days in Odoo 18Celine George

Ancient Stone Sculptures of India: As a Source of Indian HistoryVirag Sontakke

Myasthenia gravis (Neuromuscular disorder)Mohamed Rizk Khodair

U3 ANTITUBERCULAR DRUGS Pharmacology 3.pptxMayuri Chavan

Origin of Brahmi script: A breaking down of various theoriesPrachiSontakke5

TERMINOLOGIES,GRIEF PROCESS AND LOSS AMD ITS TYPES .pptxPoojaSen20

History Of The Monastery Of Mor Gabriel Philoxenos Yuhanon Dolabanifruinkamel7m

How to Create Kanban View in Odoo 18 - Odoo SlidesCeline George

How to Share Accounts Between Companies in Odoo 18Celine George

Transform tomorrow: Master benefits analysis with Gen AI today webinar, 30 A...Association for Project Management

APGAR SCORE BY sweety Tamanna Mahapatra MSc PediatricSweetytamannaMohapat

How to Manage Upselling in Odoo 18 SalesCeline George

spinal cord disorders (Myelopathies and radiculoapthies)Mohamed Rizk Khodair

Database Concept - ERD Mapping to MS Access

1. Oum Saokosal Master of Engineering in Information System Jeonju University, South Korea O12-252-752 Mapping: Chen ERD to Table Relationship

2. Notation in Chen's E-R Diagram  Entity Note: An Entity in ER is an interested Entity.  Relationship  Weak Entity  Identifying Relationship Student Register Play on

3. Attribute  Attribute (XXX 1 – 1 dob)  Multi-valued Attribute (XXX 1 – M tel)  Composite Attribute (XXX M – 1 address)  (XXX 1 – 1 address)  Multi-valued Composite Attribute (XXX 1 – M Category)  Derived Attribute (XXX 1 – 1 age) dob tel address age House Street category code description

4. Mapping: 1-N Seller make Purchase 1 N hire_date id name tel other id date name Customer tel Note: in ER diagram, seller id is not included in the table Purchase. It is the foreign key referenced from the table Seller. However, in the table relationship, seller id has to be included the table Purchase in order to make it 1-to-M relationship.

5. Mapping: 1-1 Student has Profile 1 1 tel id name sex address father photo favorite other mother Note: st_id: Autonumber pro_id: Number

6. Mapping: M-N Student Register Class M N register date reg id tel id name sex address id name year semester capacity

7. Mapping: ISA Relationship Student tel id name sex address isa Bachelor Master PhD publication research thesis dissertation Note: In Student: st_id: Autonumber In Bachelor, Master, PhD: st_id: Number

8. Mapping: M-N Tenary Student Register Class M N register date reg idtelid name sex address id name year semester capacity Cashier name tel T

9. Mapping: M-1 Unary (1) Employee tel id name sex address Report to M 1 Cannot enter 4 in table em_report_to because no em_id = 4 yet.

10. Mapping: M-1 Unary (2) SELECT S.em_id, S.em_name AS Boss, T.em_id, T.em_name AS Staff FROM tbl_employee AS S, tbl_employee AS T WHERE S.em_id = T.em_report_to;

11. Mapping: M-N Unary Employee tel id name sex address Report to M N

12. Oum Saokosal Master of Engineering in Information Systems, Jeonju University, South Korea 012-252-752 oum_saokosal@yahoo.com End of Chapter

Database Concept - ERD Mapping to MS Access

Recommended

More Related Content

Viewers also liked (20)

Recently uploaded (20)

Database Concept - ERD Mapping to MS Access