Distributed Database Presentation

Distributed Database Presentation Link

Link to Genomic Database presentation

Genomic Database Link

Project and Class Tonight

An exciting night...the reveal of your projects. I'm looking forward to seeing the results. Christine Huyber from the Biomechnics Lab will be visiting as we discussed to tell you a little more about their lab and get a first look at your results. See you all soon.

Link to Mobile Database Presentation

Mobile database link

Condition table question

We have a question about the Condition table. We noticed that in the old "spreadsheet" version of the data, there are 8 Condition columns. Which of the following does this mean?

1. A patient can have multiple conditions simultaneously

2. A patient can have one condition at a time and we are simply keeping track of the history

We just wanted to clear this up because it doesn't really make sense for a patient to for example be both "stable" and "critical" at the same time.

If it is option 2, should we have functionality in the UI to see a history of conditions with an associated date for each patient? Or leave this for future work?

Mayo Project Development

http://cs.winona.edu/faculty/nanderson/485-s10/UIAssignment4.pdf

Multimedia Databases Questions

1. What is MARS?
- Multimedia Analysis and Retrieval System

2. What are the two retrieval models in MARS?
- Fuzzy Boolean Retrieval
- Probabilistic Boolean Retrieval

3. What are the two levels of normalization in MARS?
- Intra-feature Normalization
- Inter-feature Normalization

4. What are the possible uses of MARS?
- Government and commercial use of sensing images
- Digital libraries
- Medical databases
- Special purpose databases

5. What is MOQL based off of?
- Object Query Language

Genomic Database Questions

• What is a gene and what is it made of?
• What is computational biology?
• What does NCBI stand for and what main genomic database does it contain?
• What does BLAST stand for and what does it do?
• What is Entrez?
• What are the two things you can search GenBank for?

Geographical Information Systems

Questions

1. Name one real world use for a GIS (Geographical Information System)?
2. What is the difference between vector and raster data?
3. Each layer of Geographical data must be accurately placed according to their .
4. Name one method for acquiring Geographical data.
5. What is the standards organization for GIS (Geographical Information System)?
1. Globally Open Geography
2. Open Geospatial Consortium
3. Open Geographical Standards
4. Association for Global systems standards

Mayo Group projects still needed

I am missing one of the group projects. We need this in order to fulfill our group assignment as well as providing feedback to each group about their instructions and their UI.

This Week's Mayo Project

http://cs.winona.edu/faculty/nanderson/485-s10/UIAssignment3.pdf

Virtualization Questions

What is Virtualization?

What are the main advantages to virtualization?

Where did virtualization get its start?

What are some of the drawbacks?

What is database virtualization?

Why is it useful?

Distributed Database questions

Sorry for posting this a little late.

Questions:

What are three advantages of distributed database systems?

What are two disadvantages of distributed database systems?

Describe one kind of concurrency anomaly.

Why can’t you use traditional load balancers for database servers?

Why is maintaining integrity difficult in distributed databases?

What is two-phase commit in a distributed database management system?

Search Engine

Questions:

1) What are spiders and what do they do in web crawling search engines?

2) How does indexing determine if something is more important than something else?

3) What are Meta Tags?

4) What is advantage of Turbo10?

5) What are the components of On2broker?

Mayo Project Question

We were wondering how big is the database going to be. Are we talking about hundreds, thousands or ten thousands of patients?

Homework 8

http://cs.winona.edu/faculty/nanderson/485-s10/UIAssignment2.pdf

ER Diagram

Here is the current ER Diagram with referringMD at patient. If anybody sees anything I forgot let me know and I'll fix it.

Mobile Database Presentation Questions

Please note the questions below have changed as of 4/11/2010 at 8:30 pm cst ~~*~~

1. What is a femtocell?


2. The acronym PEIR stands for what environment report.

3. What are the three parties that mobile databases typically involve?

4. When it comes to mobile databases, users don't require access to truly live data.  What type of data do they truly need access to?

5. Name two possible Mobile database problems.

mySQL server setup tips

To "make the connection" between mySQL and Razor you need to download mySQL server (I am using 5.5) and install it. Configure your instance of MySQL using the menu option (in the start menu under MySQL, MySQL server 5.5, Server Instance Config Wizard.

Here are some oif the options I used:
Detailed configuration
Developer Machine
Non-Transactional Database Only
Manual Setting
Concurrent connections: 15
Enable TCP/IP Networking
Port Number 3306
Enable Strict Mode
Standard Character Set
Check Include Bin Directory in Windows PATH
****This next step is important***
Modify Security Settings
Current root password:  - this should be left blank
New root password:  if you wish to set a password for the "root" user ID enter it here
Confirm: Re-enter the password if you entered a new root password
Execute - Make sure the Start Service on this steps completes successfully

Once this is done you can install razor and make the connection to the MySQL server instance you just configured.

Homework 7

http://cs.winona.edu/faculty/nanderson/485-s10/UIAssignment.pdf

EDI presentation

Here is my presentation on Electronic Data Interchange:

http://docs.google.com/leaf?id=0BxSOK3LMFV4bNGU2NTMxZjctMjFkNS00MzJhLWEyMzMtNmM2NWEyZWE2MDY5&hl=en

Data Compression Presentation

Here is the data compression powerpoint:

http://docs.google.com/leaf?id=0B-Z0srsHOylXMTAzNzdjODctMWMwZC00MmQ3LTg3YTEtMmVjNDdlODI5MDBl&hl=en

GUI powerpoint presentation

Here is the link to our PPT presentation:

GUI PPT on GoogleDocs

Data Warehouse Power Point File

Here is the link:

http://docs.google.com/present/edit?id=0AQGsdO58rtAZZGY5OXFrNGdfMWc4NGd4cmM2&hl=en

EDI Questions

1. When would you want to use EDI?

2. Which standard would you use if you were an international company?

3. What is one thing that a VAN offers?

4. Open or Web based EDI came into prominence because?

5. What is the main reason for the future of EDI?

6. What are the three advantages of EDI?

Condition Tables

create table Condition

(conditionID int,

name varchar(30),

primary key(conditionID));

insert into CONDITION (conditionID, name) values (1, 'Stable');

insert into CONDITION (conditionID, name) values (2, 'Recovory');

insert into CONDITION (conditionID, name) values (3, 'Critical');

insert into CONDITION (conditionID, name) values (4, 'Critical but Stable');

create table PatientCondition

(conditionID int,

clinicNum int,

primary key(conditionID, clinicNum),

foreign key (conditionID) references condition (conditionID),

foreign key (clinicNum) references patient(clinicNum));

insert into PATIENTCONDITION (conditionID, clinicNum) values (1, 100000001);

insert into PATIENTCONDITION (conditionID, clinicNum) values (2, 100000002);

insert into PATIENTCONDITION (conditionID, clinicNum) values (3, 100000003);

insert into PATIENTCONDITION (conditionID, clinicNum) values (4, 100000004);

Database Creation Update

All of the posted SQL statements posted with one exception have been successfully loaded to our class database.  The Tape table discrepancy still needs to be resolved and re-posted.

We are still missing the following:
Table Creation SQL Queries for:
Condition
PatientCondition

Data insertion SQL Queries for:
Condition

PatientCondition
VisitResearchStudy

Everyone on our team will post a couple of tables. Here are the two ICD9 tables:


CREATE TABLE mayoproject.ICD9ProcedureCode
(
ICD9ProcedureCodeID INT(9),
ICD9ProcedureCode VARCHAR(15),
clinicNum INT(9),
PRIMARY KEY(ICD9ProcedureCodeID)

);


ALTER TABLE mayoproject.ICD9ProcedureCode
ADD FOREIGN KEY (clinicNum)
REFERENCES mayoproject.patient(clinicNum);


CREATE TABLE mayoproject.ICD9Diagnostic
(
ICD9DiagnoticID INT(9),
ICD9Diagnostic VARCHAR(15),
clinicNum INT(9),
PRIMARY KEY(ICD9DiagnoticID)
);


ALTER TABLE mayoproject.ICD9Diagnostic
ADD FOREIGN KEY (clinicNum)
REFERENCES mayoproject.patient(clinicNum);


INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (1, '01.02', 100000001);

INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (2, '01.41', 100000002);

INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (3, '01.52', 100000002);

INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (4, '39.64', 100000004);

INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (5, '92.32', 100000003);

INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (6, '84.3', 100000005);


INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (1, '001-139', 100000001);

INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (2, '771.2', 100000002);

INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (3, '079.53', 100000002);

INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (4, '090-099', 100000004);

INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (5, '062.5', 100000003);

INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (6, '066.1', 100000005);

AssistiveDevice and PatientAssistiveDevice Tables

CREATE TABLE mayoproject. AssistiveDevice( AssistiveDeviceID INT (9), Name VARCHAR (15), PRIMARY KEY (assistiveDeviceID) );

CREATE TABLE mayoproject. PatientAssistiveDevice( AssistiveDeviceID INT (9), ClinicNum INT (9),
FOREIGN KEY (clinicNum) REFERENCES mayoproject.patient (clinicNum);

FOREIGN KEY (assistiveDeviceID) REFERENCES mayoproject.AssistiveDevice (assistiveDeviceID); );


INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (1, ‘walker’);

INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (2, ‘quad cane’);

INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (3, ‘crutches’);

INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (4, ‘canes’);

INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (6, ‘walker’);

INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (7, ‘quad cane’);

INSERT INTO mayoproject.PatientAssistiveDevice (assistiveDeviceID, clinicNum) VALUES (1, 100000001);

INSERT INTO mayoproject.PatientAssistiveDevice (assistiveDeviceID, clinicNum) VALUES (2, 100000002);

INSERT INTO mayoproject.PatientAssistiveDevice (assistiveDeviceID, clinicNum) VALUES (3, 100000004);

INSERT INTO mayoproject.PatientAssistiveDevice (assistiveDeviceID, clinicNum) VALUES (4, 100000003);

INSERT INTO mayoproject.PatientAssistiveDevice (assistiveDeviceID, clinicNum) VALUES (5, 100000006);

mayoproject database tables and data are still needed

I do not see the tables and insertion of data statements for Keith et al team.

Also the Tape table has a discrepancy in the backup data type and the data that you have in the data insertion statements that needs to be resolved.

Five Data Warehouse Questions:

1) What is the main goal of a data warehouse application?
2) What is data warehouse row level security?
3) What does ETL stand for?
4) List three Business Intelligence Tools?
5) What are the three factors that make up a Business Contextual Model?

Ray and Tom's GUI questions

Q1 - name one of the GUI front ends that we discussed
Q2 - name one of the characteristics of the GUIs
Q3 - name one of the "usability" of the GUIs
Q4 - name one of the "unique" feature of the GUI (need to name the feature and the GUI)
Q5 - name one of the GUIs that can access more than 1 database.

Tongun Data Mining

Q. what is data mining?.
Q.Name two commonly used techniques in data mining.
Q.What is a data warehouse?.
Q.What are the advantages of data mining over traditional approaches?.
Q.In database what is the validity of the stored data.
A. data integrity
B. mining
C. Processing
D. Independence.

Jena and Robbie Data Compression ?'s

Q: What are two advantages of digital data?

Q: What is data compression?

Q: What are the three reasons that data compression is needed?

Q: What is lossless compression and what is it good for?

Q: What is lossy compression and what is it good for?

Q:What is perceptual coding?

Tables: File, ResearchStudy, VisitResearchStudy, PatientStudy, SystemUsed, VisitSystemUsed

CREATE TABLE VisitSystemUsed(
systemUsedID INT,
visitID INT,
FOREIGN KEY (systemUsedID) references SystemUsed(systemUsedID),
FOREIGN KEY (visitID) references Visit(visitID)
);

INSERT INTO VisitSystemUsed(systemUsedID, visitID) VALUES (0300, 8), (0400, 9), (0200, 4);


ResearchStudy(IRBNum, name, description)
SystemUsed(systemUsedID , name)
 


 
CREATE TABLE ResearchStudy (
IRBNum INT(6),
name VARCHAR(30),
description VARCHAR(50),
PRIMARY KEY (IRBNum))
 
CREATE TABLE SystemUsed (
systemUsedID INT(4),
name VARCHAR(30) NOT NULL DEFAULT 'EMG-Surface',
PRIMARY KEY (systemUsedID))

INSERT INTO `mayo project`.`researchstudy` (`IRBNum`, `name`, `description`) VALUES ('000001', 'ResStudy1', 'Description1');
 
INSERT INTO `mayo project`.`researchstudy` (`IRBNum`, `name`, `description`) VALUES ('000002', 'ResStudy2', 'Description2');
 
INSERT INTO `mayo project`.`researchstudy` (`IRBNum`, `name`, `description`) VALUES ('000003', 'ResStudy3', 'Description3');




CREATE TABLE PatientStudy (
studyID INT,
visitID INT,
PRIMARY KEY(studyID, visitID),
FOREIGN KEY(studyID) REFERENCES Study(studyID),
FOREIGN KEY(visitID) REFERENCES Visit(visitID)
);


INSERT INTO PatientStudy(studyID, visitID) VALUES('1001','1');
INSERT INTO PatientStudy(studyID, visitID) VALUES('1001','2');
INSERT INTO PatientStudy(studyID, visitID) VALUES('1001','3');
INSERT INTO PatientStudy(studyID, visitID) VALUES('1002','3');
INSERT INTO PatientStudy(studyID, visitID) VALUES('1002','5');
INSERT INTO PatientStudy(studyID, visitID) VALUES('1004','6');
INSERT INTO PatientStudy(studyID, visitID) VALUES('1004','2');



CREATE TABLE File(
filename CHAR(25),
clinicNum INT (9),
PRIMARY KEY(filename),
FOREIGN KEY(clinicNum) REFERENCES Patient(clinicNum)
);
INSERT INTO File(filename, clinicNum) VALUES('file1.xml', 100000001);
INSERT INTO File(filename, clinicNum) VALUES('file2.xml', 100000002);
INSERT INTO File(filename, clinicNum) VALUES('file3.xml', 100000003);




CREATE TABLE VisitResearchStudy (
visitID INT,
IRBNum INT,
Foreign Key (visitID) references Visit(visitID)),
Foreign Key (IRBNum) references ResearchStudy(IRBNum));

Tape table data insertion error to resolve

I ran the create table statement without any problems, but when I went to insert the data there is a discrepancy in the column backup which was created as a varchar(2), but the insertion of the data has 4 characters.  Please alter the table or the data insertion statements to correct the discrepancy and repost so everyone has the correct SQL statements.  Thanks much!

Tape Table

Here are the values for the tape table:

http://docs.google.com/Doc?docid=0AeZ0srsHOylXZGY3N2JkZjRfMGdkdG41Y2Zq&hl=en

billingCodes Table

CREATE TABLE BillingCodes
(billingCodeID INT NOT NULL,
visitCharge DOUBLE,
CPTCode INT,
integerIncrement INT,
visitID INT(4),
FOREIGN KEY (visitID) REFERENCES Visit(visitID))

ALTER TABLE BillingCodes
ADD PRIMARY KEY(billingCodeID)
//note: I forgot to add the primary key so I had to do this 'ALTER' query to get it done.



INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000111, 120.32, 1000, 1, 1);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000112, 98.58, 1001, 3, 2);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000113, 508.13, 1002, 1, 3);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000114, 988.46, 1003, 2, 4);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000115, 319.01, 1004, 5, 5);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000116, 274.99, 1005, 1, 6);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000117, 1014.11, 1006, 2, 7);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000118, 63.63, 1007, 10, 8);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000119, 666.74, 1008, 12, 9);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000120, 780.00, 1009, 6, 10);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000121, 381, 1010, 5, 11);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000122, 890.54, 1011, 4, 12);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000123, 200.00, 1012, 7, 13);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000124, 150.59, 1013, 8, 14);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000125, 563.49, 1014, 8, 15);

study table

this syntax of study table and input value.
CREATE TABLE `study` ( `studyID` int(11) NOT NULL, `studyName` varchar(45) NOT NULL, PRIMARY KEY (`studyID`))
//////////////////////////////////////////////////////////////
INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1001', 'study A');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1002', 'study B');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1003', 'study C');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1004', 'study D');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1005', 'study E');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1006', 'study F');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1007', 'study G');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1008', 'study H');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1009', 'study I');INSERT INTO `study` (`studyID`, `studyName`) VALUES ('1010', 'study J');

Presentation Schedule

http://cs.winona.edu/faculty/nanderson/485-s10/PresentationSchedule.pdf

Patient & Visit Tables are loaded

Patient and Visit tables and the data statement have been successfully loaded into a mysql database called mayoproject - Yea!

Data insertion error to be resolved please

I cannot insert data using your statements posted.  The error message is listed below.  I get a similar error when I try to insert 1 row of data or all rows of data.

The problem is that height is a column with 3 digits, 1 of which is after the decimal point and you have listed a 4 digit number for height.

Since other people will be using this information I think it would be best if the creators of these statements make the changes they would like to have made and re-post the SQL statements.  Just my opinion.

Link to Source to Patient and Visit tables - UPDATED Saturday 3/27/10 at 1:30p

Class:

I had made an entry in Nicole's post about the schema, but in case you did not see my post there, I am creating a separate post to hightlight the MySQL source code to create the tables "Patient" and "Visit". You will need to create the MySQL database with a name of "mayoproject". (without the quotes of course)

Here is the link to the source:

Source file on GoogleDocs

UPDATE:
There was an error in the original posting of the source for the create table for patient in the height and weigth fields. They should have been 5,1 and not the 4,1 and 3,1 that was posted earlier. I have updated the source on Google Docs as well.

Post request

Ray or Tom, can you post a link/information about the mySQL product you mentioned in class tonight that you have found to work the best for you?  Thanks much!!

PRESENTATION DATES

Nicole,
Are you going to post the presentation dates

Class ERD from 03242010

Schema for Assignment

http://cs.winona.edu/faculty/nanderson/485-s10/MayoSchema.pdf

Homework 6

http://cs.winona.edu/faculty/nanderson/485-s10/hw6.pdf

Response to Travis's Question

For some reason blogger won't let me reply to the post at the moment. Regardless, yes, this is correct. The total of all items in an order.

Exam question 1

I was just kinda curious on this. With the total cost attribute did you mean the total cost of the entire thing or each individual meal. With my current setup that is how I had to do it. I just want to be sure that that is what you meant.

exam

Hi Nicole,
do we have to use create constraints check (...........) or we can use another technique?

examquestion

do we need to use alter table PAYMENT
add constraint CHK_PAYMENT_3 to
check the condition of credit use only when the total is over $5. ???

this means that we do not check cash or debit. and the cash and debit
will not be working after this constranins is inforcing.

order is a reserved word in SQL

I'm not sure if this was ever mentioned in class or anything, but "order" is a reserved word in SQL, so you cannot (in MySQL, anyway) create a table named "order". The error I was getting when I was attempting to do this was not very clear, so it took a while to realize that this was the problem.

So, if any of you run into this, renaming the table to something like "customer_order" should work fine.

Firebird procedure example

Here is an example of how to write a procedure in Firebird using an existing relation called CUSTOMER

SET TERM ^ ;

CREATE PROCEDURE NEWCUSTNUM

RETURNS
 ( custNum2 integer, CUST_No integer, CUSTOMER varchar (25) )
AS

BEGIN
  custNum2 = 7000;
  for SELECT CUST_NO, CUSTOMER
FROM CUSTOMER
WHERE CUSTOMER.CUST_NO >=1000 AND CUSTOMER.CUST_NO <=1009

into :CUST_NO, :CUSTOMER

DO
begin
custNum2 = 7000 + :CUST_NO;
suspend;

END
end^
SET TERM ; ^

 

Homework 5

http://cs.winona.edu/faculty/nanderson/485-s10/hw5.pdf

Research Presentation

http://cs.winona.edu/faculty/nanderson/485-s10/ResearchPresentation.pdf

Stored Procedures Advantages

I found this in the book "The Guru's Guide to SQL Server Stored Procedures, XML, and HTML" by Ken Henderson and thought it might be helpful to the class:

Stored Procedure Advantages
Although you can do most of the things a stored procedure can do with simple ad hoc Transact-SQL code, stored procedures have a number of advantages over ad hoc queries, including

• Execution plan retention and reuse
• Query autoparameterization
• Encapsulation of business rules and policies
• Application modularization
• Sharing of application logic between applications
• Access to database objects that is both secure and uniform
• Consistent, safe data modification
• Network bandwith conservation
• Support for automatic execution at system start-up

Stored Procedure Question

Can you create a stored procedure that uses more than one relation?

Homework 4

http://cs.winona.edu/faculty/nanderson/485-s10/HW4.pdf

Homework 3

http://cs.winona.edu/faculty/nanderson/485-s10/HW3.pdf

SQL error that needs some feedback

count of column list and variable list do not match

We are getting this error on one of our queries and I am not sure how to approach a solution.  Any suggestions from the class?

Homework 2

http://cs.winona.edu/faculty/nanderson/485-s10/HW2.pdf

Tonight

There is some bad weather expected for this evening. Due to this, for tonight only I've reserved an ITV room so that those of you in Winona will not need to make the trek to Rochester on potentially dangerous roads. In Winona, the CS Meeting Room (I believe Watkins 103) will be the place to be. In Rochester, we will be moving to ST118. We will start class at about 10 after 6 so that I may round up students who go to our regular classroom. Remember, this change is for tonight only.

Normalization

Here is a great link for review on normalization http://databases.about.com/od/specificproducts/a/normalization.htm

Chapter 7 of our book also has additional information on normalization.

Welcome

Welcome to the course blog for CS485. This will be the place to post comments, questions, and have discussions related to the course.