Celestial Coding

Have a list put together by chance? I wanted to add some new sub forums myself. (more specific support forums)

Alright, for one of my studies I am beginning to work with databases (We have no prior knowledge to programming with them, it is a learn as you go.) At my disposal I have web space and a multitude of programs to program SQL and transfer the files between the server and my computer.

Given:
Following are the database schemas, and the database instance with the existing tuples. All the primary keys are underlined. Other candidate keys (CK), and foreign keys (FK) are specified. Any attribute that is nullable is specified otherwise the attribute can not be null (not null).

RecCenterMember (id, f_name, l_name, dob, family_id)
FK: family_id references id in Family_Package
Family_id nullable

Class (id, title, type, instructor, season, year)
Attribute season may be “Spring” or “Summer” or “Fall” or “Winter”
FK: type references type in Type
FK: instructor references id in Instructor

Instructor (id, f_name, l_name, member_id)
FK: member_id references id in RecCenterMember
Member_id nullable

Type (type, description)

FamilyPackage (id, address, phone)
CK: phone

Enrollment (class_id, member_id, cost)
FK: class_id references id in Class
FK: member_id references id in RecCenterMember

---

Accomplish:

1.
a) Create all the tables with the specified attribute names, as listed above, with appropriate constraints such as primary keys, foreign keys, unique attributes, value check, and defining nullability. Put all the DDL statements in a file create.sql and create the tables and constraints running the batch of SQL statements from this file. You may also put in any comments you have on the creation of your tables.
b) Insert the data into the tables, using a batch of insert statements from insert.sql.
2. What is the phone number of the O’Shea’s family?
3. Give the name of the instructors who taught in both the Spring and Fall of 2009 and the description of the classes that they taught in the two semesters.
4. Give the name of the instructor who has taught the most total classes since data have been kept.
5. Give the average ages of the recreation center members who are younger than 50 years old and those who are older than 50 years old.
6. Give the distinct types of classes that were offered in 2008 and 2009 along with their descriptions.

What I have accomplished in my 'create.sql' file:

Create table RecCenterMember(id int identity(1,1) primary key,f_name varchar(50),l_name varchar(50), dob varchar(50),family_id int)
Edit 1:
Create table RecCenterMember(id int,f_name varchar(50),l_name varchar(50), dob varchar(50),family_id int, primary key(id))

Edit 2 Some progress has been made, still unsure if it is entirely right.
Create table RecCenterMember(id int, f_name varchar(50),l_name varchar(50),dob varchar(50),family_id int,primary key(id),foreign key(family_id) references FamilyPackadge
/
Create table Class(id int, title varchar(50),type varchar(50),instructor varchar(50),season varchar(50),year int,primary key(id),foreign key(type) references Type,foreign key(id) references instructor)
/
Create table instructor(id int, f_name varchar(50),l_name varchar(50),member_id int,primary key(id),foreign key(member_id) references RecCenterMember)
/
Create table Type(type varchar(50), description varchar(100),primary key(type))
/
Create table FamilyPackadge(id int, address varchar(50),phone varchar(50),primary key(id),unique(phone))
/
Create table Enrollment(class_id int, member_id int, cost numeric(12,2),primary key(class_id),foreign key(class_id) references Class,foreign key(member_id) references RecCenterMember)
/
Edit 4: Much progress has been made (still doing this solo)
Create table FamilyPackage(
id int,
address varchar(50),
phone varchar(20),
primary key(id),
unique(phone))
/
Create table RecCenterMember(
 id int,
 f_name varchar(20),
 l_name varchar(20),
 dob date,
 family_id int,
 primary key(id),
 foreign key(family_id) references FamilyPackage)
/
Create table Instructor(
 id int,
 f_name varchar(20),
 l_name varchar(20),
 member_id int,
 primary key(id),
 foreign key(member_id) references RecCenterMember)
/
Create table Type(
 type varchar(20),
 description varchar(40),
 primary key(type))
/
Create table Class(
id int,
title varchar(20),
type varchar(20),
instructor varchar(20),
season varchar(20) constraint chk_season CHECK(season IN('Spring',
'Summer',
'Winter',
'Fall')),
year int,primary key(id),
foreign key(type) references Type,
foreign key(id) references Instructor)
/
Create table Enrollment(
 class_id int,
 member_id int,
 cost numeric(12,2),
 primary key(class_id,member_id),
 foreign key(class_id) references Class,
 foreign key(member_id) references RecCenterMember)
/

I am currently putting random data into the tables.

Do I know if I am doing it right? no, but I understand that this created a table and I can store into it with Insert. I am in need of some help in understanding a way to tackle this (I assume if you know SQL this is a rather simple task as i don't see anything too complex being asked, could be wrong though.)

Welcome, this is a resource to learn and share, use it however you please.

http://www.gamesforwindows.com/en-US/Games/AgeofEmpiresIII/


So yeah, Microsoft is deciding to sell age of empires III for 10 cents.

If I ever get a pre-made computer I'll make sure to wipe it then re-install windows, they put so much crap on there.


also on my old computer I had a graphics card problem as well where the graphics card wouldn't register newer drivers, so I went two updates back and found a driver that worked perfectly.

Working on a script to run through grease monkey, and I was wondering if anyone knew how to make it as if a mouse was clicking at pre-determined locations.


ex.
I put in a coordinate location in the script in a loop, and it will click that location every time it goes through the loop.

Wow, watch this sort of thing take advantage of Kinect or some other interactive technology, would be very entertaining.

Alright, I have a little story while I was at my friends house a few days ago ( Computer Related )

So we were on his two computers playing G mod LAN, and I can hear weird noises from his computer (sounded like popcorn)

It gets louder, and then the computer shuts off.

I ask him "I think it over heated, how  long has it been on?"

Him: "9 days or so"

Me: "-.-"

So we open it up, and sure enough, the GPU is melted basically ( the fan looked like a melted candle ) and most of the capacitors are charred and shot liquid everywhere.


To those who don't have great cooling, turn your computer off at night...


Upside to the story?

I built him a new computer ^.^

Based on this I have an idea


We should develop a background application/process that will see what games you play, and hours you spend, stuff like that into it's own system.

Watch us add a little avatar to it that grows with computer use, we could sell it, Lol

Thank you all. It's nice to have people wishing you a happy birthday, even if you are halfway around the world...as I fall fast asleep, in my Glassboro apartment, dreaming of what I want to be. So I just organize photographs, I've taken in this year that's past. Love's nothing more; adores my memories. Does she miss any kiss, that I placed upon her lips? Does she have a photograph of me at all? That day she walked away, I turned my head and didn't pay attention, "she" said California is my final fall. Last time I saw her was the first time that I saw her cry. She had a boyfriend and a tattoo of a butterfly. Biology, photography ambition, was enough for her to leave me. I swore I'd find on the other side. Bloomfield Avenue! I'm sick of picking through the dumpster for a meal. I hold a gun but I can't feel it to my head. Hum a song, say goodnight, it's all wrong, it's alright. I close my eyes and take a bite...Another thing I should've said, light another cigarette, another thing I left behind, ashes to ashes, we all fall down! I'm homeless on the West, she's on the east. I only wish that I could see her one more time. To remind her that I love her and I shot him down. Now she's in that crazy town again. Hitchhike my way across the states. I'm banging on the door. She's passed out on the floor; sawed off shotgun by her side, no one heard her cry. My tears roll down the wood of our old neighborhood. I saw her through the window but I didn't have the strength to knock it down...another thing I should've said, light another cigarette, another thing I left behind, ashes to ashes, we all fall down!

Catch-22

Here is some source for a recursion program to print a string backwards, and yes I know it isn't the most efficient.

Pretty sure my computer wouldn't let that program do anything like that >.<

I didn't try any alternative programs, but I did change sleep mode power settings built in to windows, It let me change network adapter settings, didn't seem to work though.

your private school is in vancouver? AWESOME MAN WE SHOULD MEET FACE 2 FACE =D

Eczuo, bring a knife......Just in case

Someone forgot to log out of their Facebook in the mac lab at school, my friend had quite a bit of fun