Discussion of the state of practice in modern database systems, with an emphasis on relational systems. Topics include database design, database system architecture, SQL, normalization techniques, storage structures, query processing, concurrency control, recovery, security, and new directions such as objectoriented and distributed database systems. Students gain hands-on experience with commercial database systems and interface building tools. Programming projects are required.
(Prerequisites: COCP 1220 Microcomputer Database) Offered Fall

• About PTC
• PSEO and You
• Set Your Career In Motion
• Academics
  • Programs of Study
    • Business & Computer Programs
    • General Education Programs
    • Health & Human Service Programs
    • Trade & Industry Programs
    • Transfer Degrees
    • Four-Year Degrees
    • Course Descriptions and Catalog
      • ACCP 1210 Principles of Accounting I (4 credits)
      • ACCP 1214 Payroll Accounting (2 credits)
      • ASCP 1231 Business Math (3 credits)
      • ACCP 1252 Principles of Accounting II (4 credits)
      • ACCP 1258 Computerized Spreadsheets (2 credits)
      • ACCP 1201 Business Law (3 credits)
      • ACCP 1260 Computerized Accounting (3 credits)
      • ACCP 2260 Cost Accounting (4 credits)
      • ACCP 2250 Intermediate Accounting I (4 credits)
      • ACCP 2265 Income Taxes (3 credits)
      • ACCP 2290 Accounting Comprehensive Review (3 credits)
      • ASCP 1265 Business Communications (3 credits)
      • MKTG 1200 Introduction to Principles of Marketing (3 credits)
      • BIOL 1255 Microbiology (3 credits)
      • CHEM 1250 Principles of Chemistry I (3 credits)
      • ECON 1250 Principles of Micro Economics (3 credits)
      • ENGL 1276 College Composition (4 credits)
      • ENGL 2280 Introduction to Creative Writing (3 credits)
      • MATH 1260 College Algebra (3 credits)
      • MATH 1265 Elementary Statistics (3 credits)
      • MGMT 1205 Introduction to Business (3 credits)
      • PHIL 1220 Human Ethics (3 credits)
      • PHYS 1250 College Physics I (4 credits)
      • PSYC 1200 Introduction to Psychology (3 credits)
      • SOCI 1200 Introduction to Sociology (3 credits)
      • SPCH 1270 Introduction to Speech (3 credits)
      • COCP 1220 Microcomputer Database (3 credits)
      • COCP 1230 Program Design & Development I (2 credits)
      • COCP 1258 Visual C/C++ Programming I (3 credits)
      • COCP 1268 Visual C/C++ Programming II (3 credits)
      • MGMT 1200 Principles of Management (3 credits)
      • COCP 1200 Introduction to UNIX (2 credits)
      • COCP 1202 Networking Basics (3 credits)
      • COCP 1231 Web Development I (3 credits)
      • COCP 1233 Intro to Object Oriented Analysis and Design (2 credits)
      • COCP 1281 Database Programming II (2 credits)
      • MFGT 1265 Electrical-Electronic Systems (3 credits)
      • COCP 1250 Microcomputer Hardware Support (3 credits)
      • COCP 1253 Microsoft Server Operating System I (3 credits)
      • COCP 1208 Network Administration I (2 credits)
      • COCP 2230 UNIX System Installation and Administration (3 credits)
      • COCP 1209 Workstation Operating System I (3 credits)
      • COCP 2290 Computer Support Comprehensive Review (4 Credits)
      • COCP 1225 Supporting Applications Users (3 credits)
      • COCP 1243 Introduction to Computer Graphics (3 credits)
      • COCP 1244 Virtual Reality I (3 credits)
      • COCP 1291 Intro to Computer Animation (3 credits)
      • COCP 2279 Virtual Reality II (3 credits)
      • COCP 2282 Immersive Systems (3 credits)
      • ASCP 1240 Intro to Anatomy & Physiology (4 credits)
      • HEOP 1210 Trained Medication Administration for Unlicensed Personnel (3 credits)
      • HEOP 1217 Nutrition in Health Care (2 credits)
      • HEOP 1218 Medical Terminology (1 credit)
      • HEOP 1219 Intro to Microbiology/Infection Control (1 credit)
      • HEOP 1208 Medical Dosages (1 credit)
      • HEOP 1226 First Aid/Basic CPR (1 credit)
      • HEOP 1231 Human Development (3 credits)
      • HEOP 1244 Certified Nurse Assistant (CNA) (3 credits)
      • PRSG 2825 Medication Administration (2 credits)
      • PRSG 2836 Basic Nursing (3 credits)
      • PRSG 2844 Adult Nursing I (4 credits)
      • PRSG 2846 Adult Nursing II (4 credits)
      • PRSG 2847 Clinical Lab I (6 credits)
      • PRSG 2851 Clinical Lab II (9 credits)
      • PRSG 2855 Role of the LPN (1 credit)
      • PRSG 2870 Obstetrics/Pediatrics (3 credits)
      • HUMS 1205 Work Place Diversity (3 credits)
      • HUMS 1230 Managing Family Cases (4 credits)
      • HUMS 1231 Health Care Policy for Families (4 credits)
      • HUMS 1233 Work Support Programs (3 credits)
      • HUMS 1241 Health Care Policy for Adults (4 credits)
      • HUMS 1242 Managing Cash Cases (4 credits)
      • HUMS 1290 Financial Worker Internship (6 credits)
      • CDEV 1220 Child Safety, Health & Nutrition (4 credits)
      • CDEV 1230 Guidance: Managing the Physical/Social Environment (3 credits)
      • CDEV 1240 Family & Community Relations (3 credits)
      • CDEV 1340 Planning & Implementing Curriculum (4 credits)
      • CDEV 2510 Internship (3 credits)
      • COCP 1201 Microsoft Operating System Basics (2 credits)
      • CDEV 2530 Challenging Behaviors (3 credits)
      • CDEV 2640 Program Planning (3 credits)
      • CDEV 2810 Early Childhood Development Practicum (3 credits)
      • CDEV 1200 Professional Relations in Early Childhood Careers (3 credits)
      • CDEV 1205 Not By Chance: Child Care that Supports School Readiness (1 credit)
      • CDEV 1206 SEEDS of Emergent Literacy (1 credit)
      • CDEV 1207 Professionalism in Early Childhood (1 credit)
      • CDEV 1210 Foundations of Child Development (3 credits)
      • CDEV 1215 Culturally Relevant and Anti-Biased Education (3 credits)
      • CDEV 1250 Infant and Toddler Development and Learning (4 credits)
      • CDEV 1290 Special Topics (1-4 variable)
      • CDEV 1350 Literature and Language Experiences (3 credits)
      • CDEV 2600 Professional Leadership (3 credits)
      • CDEV 2620 Inclusion: Special Needs and Mixed Age Groups (3 credits)
      • ATMP 1207 Basic Electricity (3 credits)
      • ATMP 1209 Vehicle Service (3 credits)
      • ATMP 1212 Introduction to Automobile Technology (3 credits)
      • ATMP 1265 Chassis (6 credits)
      • ATMP 1219 Brakes (3 credits)
      • ATMP 1230 Engines (6 credits)
      • ATMP 1240 Current Practice (1 credit)
      • ATMP 1243 Drive train (3 credits)
      • ATMP 1248 Automatic Transmissions (6 credits)
      • ATMP 1250 Engine Electrical (3 credits)
      • ATMP 1255 Fuel Systems with OBD II (6 credits)
      • ATMP 1267 Chassis II (3 credits)
      • ATMP 1273 Accessories with Heating and AC (4 credits)
      • ATMP 1275 Wiring and Electrical Diagnosis (3 credits)
      • ATMP 1280 General Shop (3 credits)
      • ATMP 1289 Scan Tools (3 credits)
      • MTTP 1208 Measuring Tools (1 credit)
      • MTTP 1220 Blue Print Reading I (2 credits)
      • MTTP 1256 Applied Machining Theory (3 credits)
      • MTTP 1257 Machining Fundamentals I (4 credits)
      • MTTP 1258 Machining Fundamentals II (4 credits)
      • MTTP 1262 Blueprint Reading II (2 credits)
      • MTTP 1279 CNC Set-up & Operate (5 credits)
      • MTTP 1277 Machining Process (2 credits)
      • MTTP 2255 CNC Programming (5 credits)
      • MTTP 2260 Cutting Tool Technology (1 credit)
      • MTTP 2263 Quality in Manufacturing (2 credits)
      • MTTP 2290 Manufacturing Capstone Project (3 credits)
      • GSTP 1205 Metal Fusion Lab (1 credit)
      • GSTP 1207 Tool Design & Fabrication Theory (1 credit)
      • GSTP 1209 Tool Design & Fabrication Lab (3 credits)
      • GSTP 1212 Handgun Theory (2 credits)
      • GSTP 1213 Handgun Lab (3 credits)
      • GSTP 1215 Accessories Installation (3 credits)
      • GSTP 1217 Marketing & ATF Regulations (1 credit)
      • GSTP 1219 Hinge & Lever Theory (1 credit)
      • GSTP 1221 Hinge & Lever Lab (2 credits)
      • GSTP 1226 Pump & Self Loader Lab (3 credits)
      • GSTP 1232 Soldering & Brazing (1 credit)
      • GSTP 1234 Pump & Self Loader Theory (2 credits)
      • GSTP 1235 Heat Treating & Metallurgy (1 credit)
      • GSTP 1245 Bolt Action Theory (1 credit)
      • GSTP 1247 Bolt Action Lab (1 credit)
      • GSTP 2233 Polishing & Blueing (3 credits)
      • GSTP 2239 Metalsmithing (2 credits)
      • GSTP 2256 Barrel & Chambering Theory (1 credit)
      • GSTP 2257 Barrel & Chambering Lab (3 credits)
      • GSTP 2259 Shotgunsmithing Theory (1 credit)
      • GSTP 2261 Shotgunsmithing Lab (2 credits)
      • GSTP 2263 Riflesmithing Theory (1 credit)
      • GSTP 2265 Riflesmithing Lab (3 credits)
      • GSTP 2267 One Piece Stock (3 credits)
      • GSTP 2269 Two Piece Stockmaking (3 credits)
      • MATH 2260 Trigonometry (3 credits)
      • PHIL 1270 Critical Thinking Skills (3 credits)
      • MFGT 1260 Introduction to Computer Aided Manufacturing (2 credits)
      • COCP 1241 Introduction to CAD (3 credits)
      • MFGT 2205 Prototyping (5 credits)
      • MFGT 2210 Reverse Engineering (5 credits)
      • MFGT 2215 Manufacturing Documentation & Processing (1 credit)
      • COCP 2241 Advanced CAD (2 credits)
      • GSTP 1203 Metal Fusion Theory (1 credit)
      • MFGT 2206 Advanced CAM (4 credits)
      • LASL 1205 American Sign Language I (3 credits)
      • LASL 1210 Numbers and Finger Spelling (3 credits)
      • LASL 1265 American Sign Language II (3 credits)
      • LASL 1270 American Sign Language III (3 credits)
      • LASL 1275 American Sign Language IV (3 credits)
      • ENGL 2200 Advanced Composition (3 credits)
      • SPCH 1250 Intercultural Communication (3 credits)
      • PHIL 1271 Critical Thinking in Modern Society (3 credits)
      • BIOL 1250 General Biology I (4 credits)
      • BIOL 1251 General Biology II (4 credits)
      • BIOL 1260 Human Anatomy and Physiology I (4 credits)
      • BIOL 1270 Human Anatomy and Physiology II (4 credits)
      • CHEM 1201 Fundamentals of Chemistry (4 credits)
      • CHEM 1251 Principles of Chemistry II (4 credits)
      • PHYS 2250 College Physics II (4 credits)
      • MATH 1256 Mathematical Thinking (3 credits)
      • MATH 1262 College Calculus 1 (5 credits)
      • MATH 2262 College Calculus 2 (5 credits)
      • AMST 1205 The Significance of the Environment in American History (3 credits)
      • HIST 1200 United States History (3 credits)
      • POLS 1205 American Government and Politics (3 credits)
      • ATMP 1223 Engine Electrical & Accessories (6 credits)
      • PSYC 1250 Life Span Development (3 credits)
      • ATMP 1222 Air Conditioning & Heating Systems (3 credits)
      • COCP 1210 Help Desk Concepts (1 credit)
      • SOCI 1220 Marriage, Family and Relationships (3 credits)
      • HIST 1200 US History 1877
      • COCP 1235 Multimedia Design Fundamentals (3 credits)
      • SOCI 1225 Human Diversity (3 credits)
      • BIOL 1262 Biology of Humans
      • POLS 1210 Environmental Politics (3 credits)
      • PRSG 2875 Psycho-Social Nursing (2 credits)
      • CRDV 1200 Career Exploration
      • AMST 1200 Popular Culture and American Social Dynamics (3 credits)
      • PSYC 1220 Environmental Psychology
      • ARTS 1229 Introduction to the Visual Arts (3 credits)
      • ENGL 1280 Introduction to Literature (3 credits)
      • PHIL 1210 Foundations of Philosophy (3 credits)
      • PHIL 1230 Philosophy of Religion (3 credits)
      • LATN 2200 Intermediate Latin I (4 credits)
      • LATN 2250 Intermediate Latin II (4 credits)
      • SPAN 2200 Intermediate Spanish Language and Culture I (3 credits)
      • SPAN 2250 Intermediate Spanish Language and Culture 2 (3 credits)
      • SOCI 1205 Drug Use and Abuse (3 credits)
      • HEOP 1206 Pharmacology (2 credits)
      • MATH 1251 Technical Math (3 credits)
      • PTCG 1225 Job Seeking (1 credit)
  • Academic Calendar
  • Transfer Information
  • Course Schedule
  • College Library
  • Online Learning and D2L
• Student Services
• Financial Aid
• Technology at PTC
• Business & Partners
• Student Life
• Current Students
• Future Students
• Staff and Faculty
• Human Resources
• The Link
• Transfer Options
• AA Degree with MRCTC

900 4th St Se. Pine City, MN 55063
(320) 629-6764 - information@pinetech.edu

www.mnscu.edu
Copyright Pine Tech 2007

Design and Developed by Himmelberger Design - Minneapolis Web Design