On Reference

This hands-on tutorial/reference/guide to MySQL and SQL Server is not only perfect for students and beginners, but it also works for experienced developers who aren't getting the most from MySQL and SQL Server. As you would expect, this book shows how to build from scratch two different databases: MySQL and SQL Server using Java. In designing a GUI and as an IDE, you will make use of the NetBeans tool. In the first chapter, you will learn: How to install NetBeans, JDK 11, and MySQL Connector/J; How to integrate external libraries into projects; How the basic MySQL commands are used; How to query statements to create databases, create tables, fill tables, and manipulate table contents is done. In the second chapter, you will study: Creating the initial three table projects in the school database: Teacher table, TClass table, and Subject table; Creating database configuration files; Creating a Java GUI for viewing and navigating the contents of each table; Creating a Java GUI for inserting and editing tables; and Creating a Java GUI to join and query the three tables. In the third chapter, you will learn: Creating the main form to connect all forms; Creating a project will add three more tables to the school database: the Student table, the Parent table, and Tuition table; Creating a Java GUI to view and navigate the contents of each table; Creating a Java GUI for editing, inserting, and deleting records in each table; Creating a Java GUI to join and query the three tables and all six. In chapter four, you will study how to query the six tables. In chapter five, you will be taught how to create Crime database and its tables. In chapter six, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In chapter seven, you will be taught to create Java GUI to view, edit, insert, and delete Suspect table data. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. In chapter eight, you will be taught to create Java GUI to view, edit, insert, and delete Feature_Extraction table data. This table has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. In chapter nine, you will add two tables: Police_Station and Investigator. These two tables will later be joined to Suspect table through another table, File_Case, which will be built in the seventh chapter. The Police_Station has six columns: police_station_id (primary key), location, city, province, telephone, and photo. The Investigator has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. Here, you will design a Java GUI to display, edit, fill, and delete data in both tables. In chapter ten, you will add two tables: Victim and File_Case. The File_Case table will connect four other tables: Suspect, Police_Station, Investigator and Victim. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The File_Case has seven columns: file_case_id (primary key), suspect_id (foreign key), police_station_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. Here, you will also design a Java GUI to display, edit, fill, and delete data in both tables. Finally, this book is hopefully useful and can improve database programming skills for every Java/MySQL/SQL SERVER programmer.

The Publication Manual of the American Psychological Association is the style manual of choice for writers, editors, students, and educators in the social and behavioral sciences, nursing, education, business, and related disciplines.

Based on the latest research in communication theory but tailored specifically for real-world application, this updated manual speaks equally to the needs of students preparing to enter the profession and those who are already fielding reference inquiries. The authors, working in consultation with a stellar advisory board of scholars and practitioners, present a convenient and comprehensive resource that will teach you how to understand the needs of public, academic, and special library users across any virtual setting—including email, text messaging, and social media—as well as in traditional and face-to-face models of communication. Packed with exercises and examples to help you practice effective reference transactions and avoid common pitfalls, this book tackles the fundamentals of the reference interview, from why it’s important in the first place to methods for setting the stage for a successful interview and techniques for finding out what the library user really wants to know; covers the ins and outs of the readers’ advisory interview; examines a wide range of contexts, such as children, young adults, parents, seniors, adults from diverse communities, and those with disabilities; presents case studies of innovative reference and user encounters at a variety of libraries; offers updated coverage of virtual reference, including new research, virtual reality transcripts, and a look at crowd-sourcing reference via social media; features new content on common microaggressions, with guidance on how to use awareness of emotion as a factor in reference interactions to ensure better outcomes; discusses topics such as respecting/protecting privacy, overcoming assumptions, implicit judgment, the importance of context, determining the real information need, and many other lessons learned from challenging reference encounters; and thoroughly addresses policy and training procedures, as well as the unique challenges faced by paraprofessionals and non-degreed staff. Find your bearings in the continually evolving hybrid reference environment through proven strategies, advice, exercises, and research from three experts in the field.

Crosslinguistic Studies on Noun Phrase Structure and Reference contains 11 studies on the grammar of noun phrases. Part One explores NP-structure and the impact of information structure, countability and number marking on interpretation, using data from Russian, Armenian, Hebrew, Brazilian Portuguese, Karitiana, Turkish, English, Catalan and Danish. Part Two examines language specific definiteness marking strategies in spoken and signed languages—differentiated definiteness marking in Germanic, double definiteness in Greek, adnominal demonstratives in Japanese, ‘weak’ definiteness in Martiniké and the special referring options made avilable by signing. Part Three examines the second-language acquisition of genericity in English, Spanish and Brazilian Portuguese. This volume will be of interest to researchers and students in syntax, formal semantics, and language acquisition. Contributors include: Željko Bošković, Patricia Cabredo Hofherr, Edit Doron, Nomi Erteschik Shir, Brigitte Garcia, Elaine Grolla, Tania Ionin, Loïc Jean-Louis, Makoto Kaneko, Marika Lekakou, Silvina Montrul, Ana Müller, Asya Pereltsvaig, Marie-Anne Sallandre, Helade Santos, Serkan Şener, Rebekka Studler, Kriszta Szendröi, Anne Zribi-Hertz.

Reprint of the original, first published in 1863. Treating of the law of Timber, Mines, Lights, Water, Support, the construction of public works, etc., etc.