· 6 years ago · Mar 28, 2019, 09:42 PM
1DROP TABLE IF EXISTS Counselor;
2DROP TABLE IF EXISTS Subject;
3
4
5CREATE TABLE Counselor (
6 counselor_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
7 first_name VARCHAR (50),
8 nick_name VARCHAR (50),
9 last_name VARCHAR (50),
10 telephone VARCHAR (25),
11 email VARCHAR (50),
12 member_since DATE DEFAULT '0000-00-00',
13 PRIMARY KEY (counselor_id)
14);
15
16
17CREATE TABLE Subject (
18 subject_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
19
20 name VARCHAR (50),
21 description TEXT,
22 counselor_idfk SMALLINT UNSIGNED,
23 PRIMARY KEY (subject_id)
24);
25
26
27INSERT INTO Counselor (first_name, nick_name, last_name, telephone,
28email, member_since)
29 VALUES ('Jake', '"The Snake"', 'Roberts', '412 565-5656',
30'snake@ifpwafcad.com', '2003-09-10'),
31 ('Andre', '"The Giant"', '', '606 443-4567',
32'bobo@ifpwafcad.com', '2001-01-12'),
33 ('Brutus', '"The Barber"', 'Beefcake', '555 555-4432',
34'beefcake@ifpwafcad.com', '2005-03-08'),
35 ('Randy', '"Macho Man"', 'Savage', '555 317-4444',
36'machoman@hotmail.com', '2000-11-10'),
37 ('Ricky', '"The Dragon"', 'Steamboat','334 612-5678',
38'r_steamboat@ifpwafcad.com', '1996-01-01'),
39 ('George', '"The Animal"', 'Steele', '412 565-5656',
40'george@ifpwafcad.com', Now()),
41 ('Koko', '"The Birdman"', 'B. Ware', '553 499-8162',
42'birdman@ifpwafcad.com', '1999-12-03'),
43 ('Greg', '"The Hammer"', 'Valentine', '617 889-5545',
44'valentino@ifpwafcad.com', '1998-05-07'),
45 ('Bobby', '"The Brain"', 'Heenan', '777 513-3333',
46'b_heenan@ifpwafcad.com', '2002-07-09');
47
48
49INSERT INTO Subject (name, description, counselor_idfk)
50 VALUES ('Financial Consultancy', 'Investment advice and financial
51planning guidance, helping you to maximize your net worth through proper
52asset allocation. This includes the stocks, bonds, mutual funds,
53insurance products, and gambling strategies proven to work.', '9'),
54 ('Existential Psychotherapy', 'Often wonder what the
55purpose of life is? After learning the basics of Existential
56Psychotherapy, you''ll understand why you''re happy when you''re feeling
57happy, and why you''re not feeling happy when you''re not happy, allowing
58you to transcend to a state of pure bliss.', '7'),
59 ('Temper Management', 'Are your angry outbursts affecting
60your relationships with loved-ones? Do tantrums at work hinder your
61ability to perform? Temper management helps you to channel your anger
62into positive, life-changing productivity.', '4'),
63 ('Past-Life Regression', 'Past-Life Regression is a
64journey of the soul, backward and forward through time, like a yo-yo.',
65'2'),
66 ('Marriage Guidance', 'Even if you share a solid, caring
67and mutually beneficial relationship with your spouse, you may both still
68need urgent counseling. There''s only one way to find out. Contact us
69now!', '1'),
70 ('Crisis Management', 'Whether you''re a fireman,
71executive CEO, or housewife, applying crisis management techniques at the
72right moment can be life-saving for you as well as all those around
73you.', '3'), ('Dream Analysis', 'Dream Analysis will allow you to delve
74into the depths of your subconcious. Your counselor will put you through
75a rigorous, disciplined training program, allowing you to remain in a
76waking state while dreaming. By the end, you''ll be able to analyse your
77dreams while you are having them!', '8'),
78 ('Hypnosis', 'Contrary to popular belief, hypnosis can be
79a powerful and effective form of counseling.', '6'),
80 ('Reiki', 'Need a massage but are afraid to let a stranger
81touch your body? Reiki could be the perfect solution for you.', '5');