"User Requirements and Relational Databases" is (2021 Revised) Chapter 1 of Essential Aspects of Physical Design and Implementation of Relational Databases, an open textbook for CST3604, Database Design.
New York City College of Technology (City Tech)
OER from the New York City College of Technology
"The Physical Data Model" is (2021 Revision of) Chapter 2 of Essential Aspects of Physical Design and Implementation of Relational Databases, an open textbook for CST3604, Database Design.
"Distributed Database Design" is (2021 Revision of) Chapter 3 of Essential Aspects of Physical Design and Implementation of Relational Databases, an open textbook for CST3504, Database Design.
"Security" is (2021 Revision of) Chapter 4 of Essential Aspects of Physical Design and Implementation of Relational Databases, an open textbook for CST3604, Database Design.
"Query Processing and Performance" is (2021 Revision of) Chapter 5 of Essential Aspects of Physical Design and Implementation of Relational Databases, an open textbook for CST3504, Database Design.
"Transaction Management" is (2021 Revision of) Chapter 6 of Essential Aspects of Physical Design and Implementation of Relational Databases, an open textbook for CST3604, Database Design.
"Transactions and the Database Recovery" is (2021 Revision of) Chapter 7 of Essential Aspects of Physical Design and Implementation of Relational Databases, an open textbook for CST3604, Database Design.
Welcome to Africana Folklore. This course explores the oral, customary and material folklore of Africans and their descendants in the Americas and the Caribbean. We will use readings and films to examine various ways West African folklore was transmitted to and survived in the New World, and how Africans in the Americas created new oral, customary and material traditions. We will compare and contrast fictional and historical folk characters from Africa, the Northern and Southern American hemispheres, with a special focus on the English, Spanish and French-speaking Caribbean. We will examine some of the customs and practices that continue to exist in those regions and how all have contributed to global culture. In addition to required readings, there will also be weekly writing exercises. This course is designed to help prepare you for further academic study in general, and African, African-American and Caribbean studies, specifically. It will introduce you to the various disciplines that inform the study of people of African descent worldwide.
This course is an introduction to modern telephone networks and interfaces. Telephone sets, the central office and the Public Switched Telephone Networks (PSTN) are discussed in detail. Private Branch Exchanges (PBX) and public switches, both digital and analog, are discussed, with emphasis on features, signaling and technology. Concludes with the transmission of audio signals through different networks. Laboratory experiments supplement the course and expose students to the fundamentals of telephony.
This is the laboratory component of Anatomy & Physiology I. The concepts covered range from anatomical terminology, directional terms, body orientation to exercises on tissues, the integumentary, skeletal, muscular and nervous systems.
This course is a continuation of Anatomy and Physiology I. It covers the study of the structure and function of the cardiovascular, respiratory, urinary, digestive and endocrine system, as well as development, metabolism, electrolytes and acid base balance.
This is the open educational resource for BIO2311: Anatomy & Physiology I. This site provides all you will need for the course including a syllabus, link to the textbook, lecture notes, assignments, and all other related resources.
This course is the first part of the two semester course of Anatomy and Physiology. It integrates the anatomy and physiology of cells, tissues, organs and human body systems, It includes the study of the gross and microscopic structure of the systems of the human body with special emphasis on the relationship between structure and function. It is based on OpenStax Anatomy and Physiology book and is supplemented by content from the Open Learning Initiative (Carnegie Mellon University Open Learning Initative) and Boundless Physiology Open Book.
Appendix 1. Case Studies for Essential Aspects of Physical Design and Implementation of Relational Databases, an open textbook for CST3604, Database Design. See attached files for additional appendices.
Arithmetic | Algebra provides a customized open-source textbook for the math developmental students at New York City College of Technology. The book consists of short chapters, addressing essential concepts necessary to successfully proceed to credit-level math courses. Each chapter provides several solved examples and one unsolved Exit Problem. Each chapter is also supplemented by its own WeBWork online homework assignment. The book can be used in conjunction with WeBWork for homework (online) or with the Arithmetic | Algebra Homework handbook (traditional). The content in the book, WeBWork and the homework handbook are also aligned to prepare students for the CUNY Elementary Algebra Final Exam (CEAFE).
Arithmetic | Algebra Homework book is a static version of the WeBWork online homework assignments that accompany the textbook Arithmetic | Algebra for the developmental math courses MAT 0630 and MAT 0650 at New York City College of Technology, CUNY.
This course is a continuation of Bioinformatics I. Topics include gene expression, microarrays, next- generation sequencing methods, RNA-seq, large genomic projects, protein structure and stability, protein folding, and computational structure prediction of proteins; proteomics; and protein-nucleic acid interactions. The lab component includes R-based statistical data analysis on large datasets, introduction to big data analysis tools, protein visualization software, internet-based tools and high-level programming languages.
This is the Open Lab Site for COM 3401, where you will find all of the course materials for Business and Professional Communication.
The aim of this course is to introduce the concepts in multi-variable calculus which are used very often in physics, engineering, chemistry, computer sciences, and other applied fields.
The course will start with an overview of points, vectors, lines, planes, and curves in three-dimensional space . We will then move on to surfaces in space, their derivatives, maximum and minimum problems. We will see how one can compute surface areas and volumes of the underlying space of a given surface. Towards the end of the course we will study three important theorems in this course: Green’s theorem, Stokes’ Theorem, and Gauss’ Theorem. These theorems have enormous consequences and applications in real life; especially in physics and engineering.
This course provides an overview of the human developmental processes from conception, through early adolescence. Some of the major topics covered are: research methods, memory, cognition, and language development. This course is also designed to promote a continuing interest in child development and to facilitate critical thinking about the social, emotional, and cognitive influences on development via lectures, videos, and in-class assignments.
Welcome to HUS 3605 Child Welfare and Family Services Course on City Tech OpenLab. You will find all course materials (syllabus and course outline, topics and reading assignments, guidelines for assignments, policies) and on this site
An OER for MAT1275, an intermediate and advanced algebra course. Topics include quadratic equations, systems of linear equations, exponential and logarithmic functions; topics from trigonometry, including identities, equations and solutions of triangles
This Open Educational Resource provides students and faculty interested in the field of Communication Design Theory with a selection of contemporary and historical media to support their research.
This course provides a basic understanding of computer modeling in physics. Topics include basics of python programming language; scientific plotting; numerical evaluation of integrals; numerical solution of ordinary and partial differential equations; visual programming; basics of high performance and parallel computing; basics of graphics processing unit programming.
This course introduces students to concepts of problem solving using constructs of logic inherent in computer programming languages. Students study the nature of problems, common solution approaches and analysis techniques. Students use a flowchart interpreter to diagram problem solutions. Students learn the basics of computer programming by learning Python. Both Python scripts and flowcharts enable students to construct solutions to common algorithmic problems. The major emphasis is on teaching the student to identify solutions to a problem and translate them into various forms that will enable the computer to perform some of the steps in a solution of an actual problem instance. These forms include flowcharting tool, viewing generated software code and the basics of debugging the code. At the end of the class students will write a project Python scripts that demonstrates the students’ knowledge of all the basic programming concepts discussed in class (e.g., variables, conditions, loops, functions).
This is the open educational resource for EDU3640: Computers in Education. This site provides all you will need for the course including a syllabus, link to the textbook, lecture materials, assignments, and all other related resources
Topics covered will include pre-construction and construction processes, construction and labor law, risk allocation and safety, accounting principles, claims and change orders, and the roles of the Project Manager and Project Superintendent throughout.
Students will also study the LEED rating system and be prepared to take a LEED certification exam at the end of this course, if qualified.
This course provides an overview of existing psychological and epidemiological findings on the relationship between behavior and disease. The course explores how behavior, emotion and cognition can influence disease processes and examines the impact of stress and perceived control of one’s destiny on coronary, immune and infectious diseases and symptoms. The biological processes of several relevant chronic illnesses are covered as well as related racial and social economic health disparities. Templates for understanding and treating chronic illness including social support, referral and interventions for optimal physical and mental health are discussed. The interdisciplinary theme of this course will provide an overview of extant literature on theories of health psychology within the context of critical race theory, epidemiology, research methods, philosophy of science, biological anthropology, sociology, as well as applied health/medical fields for an enriched understanding of the biopsychosocial approach to health and illness. Lectures and in-class activities as well as films, guest lecturers, and interactive computer programs make up this textbook-free course with required readings made available via CityTech’s OpenLab and Open Educational Resources (OER).
With New York City as a world food culture laboratory, students will explore the concept of culinary tourism and its economic impact on the tourism industry. Students will create, market and conduct their own NYC culinary walking tour.
This combined ENG92W and ENG 1101 course aims to simplify the process of translating ideas and thoughts from your brain to the page. Through critical readings, analysis of visual materials, research, and self-exploration, you will gain basic writing tools and gain confidence in recognizing your unique ideas and develop methods to convey them
During this course, students will discover the fundamental concepts
of electronic commerce and understand how to analyze these concepts from
both a business and technical standpoint with a particular emphasis on
the fashion industry. In real time, students will examine the impact and changes of
e-Commerce in the business of fashion, including various alternative
approaches to creating e-Commerce solutions. Topics covered include the
history of e-Commerce and the development of the World Wide Web,
e-Commerce tools and technologies, Internet advertising and marketing
strategies and the legal, security and taxation issues critical to the
success of any e-Commerce venture.
Course Description: A course in effective essay writing and basic research techniques including the use of the library. Demanding readings assigned for classroom discussion and as a basis for essay writing.
Instructor: Anthony Wheeler
Course: ENG1121 English Composition II (O470)
This project was originally created as part of the Mina Rees Library's Open Pedagogy Fellowship at The Graduate Center (Winter 2021).
As one of the standard upper-level physics courses required by any BS programs in Physics, PHYS 3200 Electricity, and Magnetism is devoted to a detailed study of the laws of electricity and magnetism, by means of the appropriate mathematical tools acquired by the students in the Calculus sequence. Aside from providing students with the opportunity of applying and testing their mathematical and computational skills, this course provides a detailed description of the fundamental laws which are the basis of innumerable technological applications.
The topics discussed in this course include electrostatics, magnetostatics, electrostatics and magnetostatics in matter, Maxwell’s equations, electromagnetic forces.
ENT 1201 is an introduction to Electrical Theory supported on practical examples and emphasizing the safe use of electricity in entertainment and media. This course also covers a quick overview of the most basic devices that manipulate and transform electricity in modern life like Generators, Transformers, Motors, etc. Electrical fundamentals such as voltage, current, power and resistance are introduced. Ohm’s law and the Power law are covered, using practical examples from the field. Simple electrical circuits, including series and parallel, are introduced. Specific methods of power generation and distribution are covered.
This is the open educational resources (OER) site for EMT 1130 (Electrical Circuits Lab). Here you can find course information, assignments, syllabus, schedule, and course materials if EMT 1130.
This text is intended for a brief introductory course in plane geometry. It covers the topics from elementary geometry that are most likely to be required for more advanced mathematics courses. The only prerequisite is a semester of algebra.
The emphasis is on applying basic geometric principles to the numerical solution of problems. For this purpose the number of theorems and definitions is kept small. Proofs are short and intuitive, mostly in the style of those found in a typical trigonometry or precalculus text. There is little attempt to teach theorem-proving or formal methods of reasoning. However the topics are ordered so that they may be taught deductively.
The problems are arranged in pairs so that just the odd-numbered or just the even-numbered can be assigned. For assistance, the student may refer to a large number of completely worked-out examples. Most problems are presented in diagram form so that the difficulty of translating words into pictures is avoided. Many problems require the solution of algebraic equations in a geometric context. These are included to reinforce the student's algebraic and numerical skills, A few of the exercises involve the application of geometry to simple practical problems. These serve primarily to convince the student that what he or she is studying is useful. Historical notes are added where appropriate to give the student a greater appreciation of the subject.
This book is suitable for a course of about 45 semester hours. A shorter course may be devised by skipping proofs, avoiding the more complicated problems and omitting less crucial topics.
The course, in addition to the theoretical texts assigned for reading and analysis, incorporates journalistic accounts of social issues, autobiographies, memoirs, oral histories and materials like photographs and film, in order to encourage students to experiment with original sociological research. Learning, also, to apply sociological language and concepts to events and situations we encounter daily, like ‘sociological location’ (identities like race, gender and class) and ‘social institutions’ (organized entities that structure society, like education and religion) is of key importance. By the end of the course, students should be well on their way to developing their own 'sociological imagination.’
This course will look at a variety of sociological writings (not necessarily written by professional sociologists) addressed to some characteristically modern phenomen—individualism, capitalism, democracy, etc.—in order to gain a clearer understanding of these often confusing elements of our modern world; to the extent that we are able to win such a clearer understanding, we shall also learn something about the unique contributions that sociology can make to such attempts. We’ll read some original texts from founding figures in the discipline—those who gave it its orienting research questions, theoretical starting-points, and distinctive methodologies. We’ll also read work by their contemporary followers in order to see whether the classical texts and approaches can still speak to our present-day condition. In the last part of the course, we’ll look at a couple of topics of general and very current interest—sex and gender, race and ethnicity, human nature—and try to see how sociologists tend to differ in their approaches to these topics from other kinds of students of the human condition.
This interdisciplinary course examines current environmental issues from a macroeconomic perspective, focusing on both the long and short-term economic viability of various proposals to address current environmental challenges. Traditional goals of economic efficiency will be examined in the context of the need to expand renewable energy sources, green design, sustainable construction and resource allocation and other efforts to combat climate change on a global scale.