Filter By
Filter Reset
Lectures
  • All Lectures
  • Lecture 1 (4)
  • Lecture 2 (2)
  • Lecture 3 (3)
  • Lecture 4 (2)
  • Lecture 5 (1)
  • Lecture 6 (1)
  • Lecture 7 (1)
  • Lecture 8 (1)
  • Lecture 9 (1)
  • Lecture 10 (1)
  • Lecture 11 (1)
  • Lecture 12 (1)
Top Professors
Semester
Class Notes (1,045,524)
AUS (35,230)
MQ (1,869)
ISYS (102)
ISYS114 (19)

Class Notes for ISYS114 at Macquarie University

Introduction to Database Design and Management

Information Systems
ISYS114
All Professors
ISYS114 Lecture Notes - Lecture 4: Multivalue, Referential Integrity, Data Integrity

24/08/18 WEEK 4 ISYS Logical Database Design and the Relational Model Components of relational model Data structure tables (relations), rows, columns, data manipulation powerful SQL operations for retrieving and modify...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 3: Subtyping, Widepoint Corporation, Abstract And Concrete

17/08/18 WEEK 3 ISYS Enhanced Entity Relationship Diagrams Enhanced ER Models Supertypes and subtypes Enhanced ER model: extends original ER model with new modelling constructs. Subtype: a subgrouping of the entities in ...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 2: Business Rule, Associative Entity, Foreign Key

100818 WEEK 2 ISYS Modelling Data in the Organisation A good data name is: Related to business, not technical, characteristics Meaningful and selfdocumenting Unique Readable Composed of words from an approved list Repeatab...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 1: Data Redundancy, Database Design, Data Integrity

030818 WEEK 1 ISYS Intro to Database Design and Management Database: organised collection of logically related datarecords Data: stored representations of meaningful objects and events. Raw facts and have no meaning Struc...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 12: Star Schema, Massively Parallel (Computing), Text Mining

Distributed database options: Homogeneous same DBMS at each node Autonomousindependent DBMSs Non-autonomouscentral, coordinating DBMS Easy to manage, difficult to enforce ...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 11: Distributed Database, Data Dictionary, Data Integrity

Backup facilities: DBMS copy utility that produces backup copy of the entire database or subset Periodic backup (e.g. nightly, weekly) Cold backupdatabase is shut down during backup Hot backupselected portion is shut down ...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 10: Mysql, Teijin, Microsoft Sql Server

Techniques for data integration: Consolidation (ETL) Consolidating all data into a centralized database (like a data warehouse) Data federation (EII) Provides a virtual view of data w...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 9: Referential Integrity, Total Quality Management, Organizational Commitment

Data governance: Data governance Highlevel organizational groups and processes overseeing data stewardship across the organization Data steward A person responsible for ensuring that organizational applications properly su...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 8: Software As A Service, Web Services Discovery, Supplier Relationship Management

Web application components: Database server hosts DBMS e.g. Oracle, SQL Server, Informix, MS Access, MySql Web server receives and responds to browser requests using HTTP protocol e.g. Apache, Internet Information Services...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 7: Visual Basic .Net, Web Browser, Java Database Connectivity

Client server architectures: Networked computing model Processes distributed between clients + servers ClientWorkstation (PC, smartphone, tablet) that requests and uses service Server Powerful computer (PCminimainframe) th...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 6: Data Integrity, Dependent Records, Foreign Key

Partitioning: Horizontal Partitioning: Distributing the rows of a logical relation into several separate tables Useful for situations where different users need access to different rows Three types: Key Range Partitioning,...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 5: Associative Entity, Third Normal Form, Functional Dependency

First normal form: No multivalued attributes Every attribute value is atomic Second normal form: 1NF PLUS every nonkey attribute is fully functionally dependent on the ENTIRE primary key Every nonkey attribute must be defi...

Information Systems
ISYS114
Charanya
ISYS114 Lecture 4: Isys114 Lecture 4

Strong vs. Weak Entities, and Identifying Relationships Strong entity exists independently of other types of entities has its own unique identifier identifier underlined with single line Weak entity dependent on a strong e...

Information Systems
ISYS114
Charanya
ISYS114 Lecture Notes - Lecture 3: Unique Key, Enterprise Resource Planning, Decision Support System

Two approaches to the database and I.S development SDLC - Waterfall System Development Life Cycle Detailed, well-planned development process Time-consuming, but comprehensive ...

Information Systems
ISYS114
Charanya

Log In


OR

Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit