collapse collapse

* Who's Online

  • Dot Guests: 81
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Board Stats

  • stats Total Members: 88
  • stats Total Posts: 11163
  • stats Total Topics: 1699
  • stats Total Categories: 4
  • stats Total Boards: 76
  • stats Most Online: 248

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - isaro

Pages: [1] 2 3 4 5 6 ... 12
1
Updates / Re: Improving Site
« on: October 17, 2012, 11:14:12 pm »
Have a list put together by chance? I wanted to add some new sub forums myself. (more specific support forums)

2
I am slowly figuring it out, it has just been a long road of trial and error, I really just needed someone to ask questions, (which I will have more of I'm sure)

3
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:

Code: [Select]
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:
Code: [Select]
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.
Code: [Select]
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)
Code: [Select]
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.)




4
Introductions / Re: World of coding
« on: April 22, 2012, 04:26:24 am »
Welcome,

Post any questions you might have and we will attempt to help you out.

5
Introductions / Re: Hi, all
« on: October 27, 2011, 03:40:46 pm »
Welcome, this is a resource to learn and share, use it however you please.

6
General Talk / Re: Terraria
« on: June 29, 2011, 12:27:57 am »
I tried it,

But kept randomly dieing when digging >.>


I do still play Mine craft though (Binary computer systems in that game are amazing)

7
General Talk / Here is a deal :P
« on: November 21, 2010, 12:48:14 pm »
http://www.gamesforwindows.com/en-US/Games/AgeofEmpiresIII/


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

8
Technology / Re: Next up on my wish list? A Transparent Monitor!
« on: September 12, 2010, 06:35:16 pm »

Although, this probably isn't for the pr0n enthusiast. But hey, maybe by the time this hits mainstream, maybe pr0n won't be so taboo. Last I heard they were warning parents about the dangers of certain audio tracks that can induce certain drug like effects.


There was a warning on the news around my area about the music that gets you high lol.

see now I wonder if it's possible to just kill someone with sound, or accomplish the brown note from south park >.>

what will they come up with next....

9
Hardware Support / Re: Video card not identified?
« on: September 12, 2010, 06:30:59 pm »
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.



10
Javascript / Re: Javascript help.
« on: August 19, 2010, 02:03:12 pm »
I'm trying to get it to click on things inside a flash game, attempting to get a bot to work.

But now I think I'm going to need to find elements on the page that link to parts of flash if I want them to be clicked on with JS.



11
Javascript / Javascript help.
« on: August 18, 2010, 10:41:51 pm »
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.

12
General Talk / Re: Alien Swarm
« on: August 08, 2010, 07:58:20 pm »
I tried it a few days ago, was decent, but I have games I'd rather be playing.

13
Technology / Re: New Physics Model shows realistic particle effects
« on: July 20, 2010, 05:10:56 pm »
Wow, watch this sort of thing take advantage of Kinect or some other interactive technology, would be very entertaining.

14
Humor / Re: Few days ago
« on: June 09, 2010, 01:36:31 pm »
When I opened up the side it was a blast of hot air, didn't expect it so I jumped back >.> felt like I opened a microwave after heating somthing for like 5 minutes.

15
Humor / Few days ago
« on: June 09, 2010, 12:27:16 pm »
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 ^.^




16
Request A Program or Tutorial / Re: C to Google
« on: April 09, 2010, 08:23:57 am »
I'm still wondering just how big wolfram alphas database really is, it seems to have an answer to anything I've asked it.

17
Technology / Re: The future game programmers
« on: April 07, 2010, 08:25:27 pm »
Based on this I have an idea :P


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


18
Technology / Re: My adventures to the Triangle Game Conference - Day 1
« on: April 07, 2010, 07:54:19 pm »
I want to go to something like that, looks fun.

19
General Talk / Re: Happy Birthday Eczuo
« on: March 25, 2010, 07:37:17 pm »


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 :D

20
General Talk / Re: Happy Birthday Eczuo
« on: March 25, 2010, 06:45:37 pm »
Happy birthday bud.

21
Java / Re: (Referance) Java Source Dump.
« on: March 24, 2010, 07:55:11 pm »
Here is some source for a recursion program to print a string backwards, and yes I know it isn't the most efficient.

Code: Java
  1. //isaro - recursion
  2.  
  3.  
  4. import java.util.Scanner;
  5.  
  6.  
  7. public class Backwards
  8. {
  9.         public static void main( String[] args)
  10.         {
  11.                 String newWord=""; // creates the empty string to store the new word
  12.                 Scanner scan = new Scanner(System.in);
  13.                 String s = new String(); // string object
  14.                 System.out.println("Enter a word: ");
  15.                 s = scan.nextLine(); // takes input in for s
  16.                 int length = s.length(); // takes the length of the word
  17.                 newWord = printBackwards(s,length,newWord); // calls the recursive function
  18.                 System.out.println(newWord); // prints out the new word.
  19.         }
  20.         public static String printBackwards(String s,int length,String newWord)
  21.         {
  22.                 if(length!=0)
  23.                 {
  24.                         newWord += s.substring(length-1,length); // gets one character from the end of the word and adds to the new word
  25.                         length--;
  26.                         return printBackwards(s,length,newWord); // recursivly uses itself.
  27.                 }
  28.                 else{
  29.                         return newWord;} // returns the complete new word.
  30.         }
  31. }

22
Python / Re: Reader Failure
« on: March 22, 2010, 08:49:50 pm »
code

Code: Python
  1. myD={}#creates Dictionary  
  2. L1=open("L1.txt")#opens files  
  3. L2=open("L2.txt")#opens files  
  4. for l1,l2 in zip(L1,L2): #do  
  5.     myD[l1.strip()]=l2.strip() #puts l1 and l2 in myD  
  6. L1.close()#end reading  
  7. L2.close()#end reading  
  8.  
  9. print myD  
  10.  
  11. T1=open("T1.txt","r")  #read only mode  
  12. mytxt=T1.readline().strip() #read part of it  
  13. T1.close() #end reading  
  14. print mytxt  
  15.  
  16. for t1 in myD:  
  17.     mytxt=mytxt.replace(t1,myD[t1]) #replaces things in the myD  
  18. print mytxt  
  19.  
  20. T2=open("T2.txt","w")  #write mode  
  21. T2.write(mytxt)  
  22. T2.close()
  23.  
  24. raw_input("Press Enter to continue")

text files
Code: [Select]
l1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

l2

a
b
c
d
e
f
g
h
i
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z

t1

purple
blue
green

Output
Code: [Select]
{'a': '1', 'c': '3', 'b': '2', 'e': '5', 'd': '4', 'g': '7', 'f': '6', 'i': '9', 'h': '8', 'k': '10', 'm': '12', 'l': '11', 'o': '14', 'n': '13', 'q': '16', 'p': '15', 's': '18', 'r': '17', 'u': '20', 't': '19', 'w': '22', 'v': '21', 'y': '24', 'x': '23', 'z': '25'}
purple
15201715115

Mine managed to run through the entire thing, I didn't change much, but I did put all the files in the same location and used different variables in the text files then you might have been using.

- EDIT - Use the ****ing python tag!


[edited name=Celestialkey date=1269309925][/edited]

I'll work on it more tomorrow, going to sleep.


[edited name=isaro date=1269312141][/edited]

FireX, I haven't been able to find out much about your error, I can't seem to repeat it with differant data.
The only thing it might be is Python is stopping itself from storing repeats in data in a dictionary somewhere along the line stopping most of it.
But if you are storing or using libraries like that, you should be using MySQL import or somthing along those lines.

try looking into a different method of storage, I'll bring up this code with some other python people.

23
Suggestions / Re: CALCULATOR --- an awsome one at that :)
« on: March 08, 2010, 09:33:38 pm »
Pretty sure my computer wouldn't let that program do anything like that >.<

24
Suggestions / Re: CALCULATOR --- an awsome one at that :)
« on: March 08, 2010, 09:19:35 pm »
I like dividing by zero T.T

instead of making the program register as malware, just make the program flash multi colors when you try dividing by zero or something :P


25
Software support / Re: Computer sleep.
« on: March 08, 2010, 08:16:06 pm »
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.

26
Software support / Computer sleep.
« on: March 08, 2010, 03:56:58 pm »
Alright, so there I have been trying for awhile now to run some small programs to keep going while my computer is in sleep mode, the programs are required to connect to the internet and I want to be able to leave them on while my computer is asleep.

My problem is my computer disconnects the internet whenever I go into sleep mode.

I'm wondering if there is any software or fixes I might have not tried to allow me to do so.

My network adapter is a linksys USB connection.

27
General Talk / Re: My Standard Break from Life
« on: March 08, 2010, 08:13:40 am »
your private school is in vancouver? AWESOME MAN WE SHOULD MEET FACE 2 FACE =D

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

28
General Talk / Re: 9000 posts!
« on: March 08, 2010, 08:11:16 am »
We owe a big thanks to our host  :)

The site has been around a good while now.

29
C++ / Re: Hack passwords using Firefox Web Browser!!!
« on: March 03, 2010, 05:00:46 pm »
Someone forgot to log out of their Facebook in the mac lab at school, my friend had quite a bit of fun :P

30
General Talk / Re: Wow... I am a GOD
« on: February 28, 2010, 04:08:18 pm »
Interesting...I'll check it out later.

Pages: [1] 2 3 4 5 6 ... 12

Donate


* Search


* Recent Posts

Image Comparison by Shishka
[May 15, 2017, 01:18:02 pm]


Re: srchub - free source code hosting by Nathan
[December 14, 2015, 11:37:02 pm]


Re: srchub - free source code hosting by Celestialkey
[November 27, 2015, 08:51:42 am]


Updates by Nathan
[October 30, 2015, 08:27:36 pm]


Re: Client-Server Messaging by Nathan
[October 25, 2015, 05:48:57 pm]