Database Design (BIT 275)

Students learn the basics of the planning and design of relational databases and the use of the Structured Query Language (SQL). Students gain hands-on experience in implementing database solutions based on criteria obtained during client-programmer role-playing exercises. Topics of study include information design, data tables and the forming of complex queries as well as implementation planning.

Prerequisites: Completion of BIT 158 and BIT 159 with grades of 2 grades of at least 2.0 or co-enrollment or evidence of work at or above that level.


Course Schedule:



Skill Standards Criteria

  1. Gather data to effectively identify customer requirements
  2. Accurately and appropriately define the project scope of work
  3. Establish a comprehensive project timeline
  4. Develop and present design concept alternatives
  5. Create and refine preliminary designs
  6. Develop comprehensive entity-relationship model
  7. Implement an effective data design that insures data integrity
  8. Hand-off deliverables within schedule to client/development team
  9. Prepare professional quality deliverables that fully satisfy project scope
  10. Completely document data design

Cascadia Community College Learning Agreement:

Academic Honesty:  The College regards acts of academic dishonesty, including such activities as plagiarism, cheating and/or/violations of integrity in information technology, as very serious offenses.  In the event that cheating, plagiarism or other forms of academic dishonesty are discovered, each incident will be handled as deemed appropriate.  Care will be taken that students’ rights are not violated and that disciplinary procedures are instituted only in cases where documentation or other evidence of the offense(s) exists.  A description of all such incidents shall be forwarded to the Vice President for Student Success, where a file of such occurrences will be maintained.  The vice president may institute action against a student according to the college’s disciplinary policies and procedures as described in the Student Handbook.  In this class, any work found to involve academic dishonesty will be (e.g., given a grade of 0.)  (insert your own policy here)

Acceptable Use Policy on Information Technology: In general, the same ethical conduct that applies to the use of all college resources and facilities applies to the use of Cascadia’s systems and technology.  These systems may only be used for authorized purposes, using only legal versions of copyrighted software, and with consideration and respect for the conservations of resources and the rights of other users.   For additional information, go to the Open Learning Center for a complete copy of the Information Technology Acceptable Use Policy and Procedures.

Disability Support Services:  Cascadia provides services to help students with disabilities successfully adapt to college life.  Students who meet specific criteria may also qualify for academic accommodations.  If you have or suspect you have a disability and need an accommodation please contact the front office in Kodiak Corner at 352-8383 to make an appointment with the Disability Support Services. Services and Accommodations through DSS are not retroactive.


Diversity:  Cascadia Community College affirms a commitment to freedom from discrimination for all members of the College community.  Celebration of diversity and cultural differences is a hallmark of a true learning community.  Pluralism, diversity and equity are therefore at the core of Cascadia’s mission.  Individual difference is affirmed and celebrated in our community of learning.


Emergency Procedures:  Emergency procedures are posted in each classroom.  To reach campus security personnel, dial 425-352-5222.  Fire and police may be reached by dialing 9-911.

Family Education Rights and Privacy Act (FERPA):  Cascadia Community College complies with the Family Education Rights and Privacy Act (FERPA) of 1974 concerning the information that becomes a part of a student’s permanent educational record and governing the condition of its disclosure.  Under FERPA, students are protected against improper disclosure of their records.  

Inclement Weather:  In the event of inclement weather affecting morning classes, there will be notification on the local media by 5:30 a.m. You may also call the main campus number: 425-352-8000 to hear a message that will be updated with the latest Cascadia closure information. You may also go online to and click on Cascadia Community College to get the latest report. Should the weather deteriorate during the day, you may check online, listen to the main campus message, check email or the media to hear news about closures or class schedule changes.    


Learning Assistance Options:  To support student success, Cascadia offers a variety of support services.  The Open Learning Center provides a place for students to receive assistance with class assignments, the e-portfolio and technology needs.  It contains a computer lab and tutoring center that houses both the Writing Center and the Math Center, where students can seek individualized tutoring on a walk-in basis.  The Open Learning Center is located in CC060.