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)
There aren't any users online.
|
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. 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
Software support / Re: [SQL] Help, attempting to begin a project with no prior knowledge.« on: September 25, 2012, 05:59:25 pm »
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
Software support / [SQL] Help, attempting to begin a project with no prior knowledge.« on: September 24, 2012, 07:30:14 pm »
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 Edit 4: Much progress has been made (still doing this solo) Code: [Select] Create table FamilyPackage( 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 »
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
![]() 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 »
Catch-22 ![]() 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
22
Python / Re: Reader Failure« on: March 22, 2010, 08:49:50 pm »
code
Code: Python
text files Code: [Select] l1 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'} 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 ![]() 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
![]() 30
General Talk / Re: Wow... I am a GOD« on: February 28, 2010, 04:08:18 pm »
Interesting...I'll check it out later.
|
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] |