Random

BA 325

WEEK 1

WEEK 2

WEEK 3 data model data table

Ambig/rep of database Tables

Attribute Column/field

Unique id Records/row

The procedure for DM

1. Idedtify entities

2.Identify relationships

3. Determine Unique id4.

5.Set foreign keys

6. Identify attributes

7. Identify cardinalities – database rules

THE STRUCTURE OF IT

Composite Keys

-animal kingdom example

Database Normalization

minimize dependency and redundancy

1. first normal form (1NF)

2. secondnormal form (2NF)

3. third normal form

3.5 - boyce-codd normal form (BCNF)

SQL ---Structured Query Language

Ex. Select * from customer where custromer_id = 1342

Key parts 1. Select -- atttributees

2. from --- what table it comes from

3. where -- date/ etc

4. Order By

Big Data

3 Vs

volume

Velocity

Variety

Google maps, facebook

THE STRUCTURE OF IT

What is a computer?

-computes things (anything that does this)

THE INFRASTRUCTURE OF IT

The parts -------→. Roads, bulidings, etc

and how they fit together --→ city/state/country

ex. Hawthorne district – buildings/houses= district

district+distrct = city

Hardware- servers, clients (computers)

Network – May be network HW

-connections/wifi router

Software – On servers and clients

SERVERS

Computers

Do the heavy lifting

LAN (local area network)

Clients communicate to servers

Run application logic

Database

DNS

Load balancing

SERVERS live in data centers

NWEA Data Center

Facebook Prineville Data Center

NETWORKS

CONNECTION OF SERVERS/COMPUTERS

Servers may do 1 task, a collections would do a set of tasks that provides value; the collection is in a network

SOFTWARE

-operating system – platform

applications

“code”

SOFTWARE TYPES

Desktop-client

Enterprise

Software package

ERP and SCM

CRM

BI

CREATE CODE TO TELL HARDWARE WHAT TO DO

EMBEDDED SOFTWARE

Software activity

Listen- thru link to...