Search
- Filter Results
- Location
- Classification
- Include attachments
- https://eng.libretexts.org/Bookshelves/Computer_Science/Databases_and_Data_Structures/Database_Design_2e_(Watt)/01%3A_Chapters/1.11%3A_Functional_DependenciesFor any relation R, attribute Y is functionally dependent on attribute X (usually the PK), if for every valid instance of X, that value of X uniquely determines the value of Y. The left side of the ab...For any relation R, attribute Y is functionally dependent on attribute X (usually the PK), if for every valid instance of X, that value of X uniquely determines the value of Y. The left side of the above FD diagram is called the determinant, and the right side is the dependent. We will use the letters X, Y, Z to represent any subset of and, for short, the union of two sets of attributes, instead of the usual X U Y.
- https://eng.libretexts.org/Bookshelves/Computer_Science/Databases_and_Data_Structures/Database_Design_2e_(Watt)/01%3A_Chapters/1.15%3A_SQL_Structured_Query_LanguageIn this example, the field HotelNo in the tblRoom table is a FK to the field HotelNo in the tblHotel table shown previously. Write the SQL code to delete the row for the person named William Smithfiel...In this example, the field HotelNo in the tblRoom table is a FK to the field HotelNo in the tblHotel table shown previously. Write the SQL code to delete the row for the person named William Smithfield, who was hired on June 22, 2004, and whose job code classification is 500. (Hint: Use logical operators to include all the information given in this problem.)
- https://eng.libretexts.org/Bookshelves/Computer_Science/Databases_and_Data_Structures/Database_Design_2e_(Watt)/01%3A_Chapters/1.12%3A_NormalizationThe PK of the new relation is a combination of the PK of the original relation plus an attribute from the newly created relation for unique identification. If the relation has a composite PK, then eac...The PK of the new relation is a combination of the PK of the original relation plus an attribute from the newly created relation for unique identification. If the relation has a composite PK, then each non-key attribute must be fully dependent on the entire PK and not on a subset of the PK (i.e., there must be no partial dependency or augmentation). We need to create a table that incorporates the first three FDs (Client_Interview2 table) and another table (StaffRoom table) for the fourth FD.
- https://eng.libretexts.org/Bookshelves/Computer_Science/Databases_and_Data_Structures/Database_Design_2e_(Watt)/01%3A_Chapters/1.06%3A_Classification_of_Database_Management_SystemsWith a centralized database system, the DBMS and database are stored at a single site that is used by several other systems too. In a distributed database system, the actual database and the DBMS soft...With a centralized database system, the DBMS and database are stored at a single site that is used by several other systems too. In a distributed database system, the actual database and the DBMS software are distributed from various sites that are connected by a computer network, as shown in Figure 6.2. distributed database system: the actual database and the DBMS software are distributed from various sites that are connected by a computer network
- https://eng.libretexts.org/Bookshelves/Computer_Science/Databases_and_Data_Structures/Database_Design_2e_(Watt)/zz%3A_Back_Matter
- https://eng.libretexts.org/Bookshelves/Computer_Science/Databases_and_Data_Structures/Database_Design_2e_(Watt)/01%3A_Chapters/1.17%3A_Appendix_A_-_University_Registration_Data_Model_ExampleHere is a statement of the data requirements for a product to support the registration of and provide help to students of a fictitious e-learning university. Using Figure A.2, note that a student (rec...Here is a statement of the data requirements for a product to support the registration of and provide help to students of a fictitious e-learning university. Using Figure A.2, note that a student (record) is associated with (enrolled) with a minimum of 1 to a maximum of many courses. A staff record (a tutor) is associated with a minimum of 0 students to a maximum of many students.
- https://eng.libretexts.org/Bookshelves/Computer_Science/Databases_and_Data_Structures/Database_Design_2e_(Watt)/01%3A_Chapters/1.16%3A_SQL_Data_Manipulation_LanguageA full outer join specifies that if a row from either table does not match the selection criteria, the row is included in the result set, and its output columns that correspond to the other table are ...A full outer join specifies that if a row from either table does not match the selection criteria, the row is included in the result set, and its output columns that correspond to the other table are set to NULL. The Vendor table contains a single attribute, VEND_CODE, with values 123, 124, 125 and 126. (The VEND_CODE attribute in the Product table is a foreign key to the VEND_CODE in the Vendor table.)
- https://eng.libretexts.org/Bookshelves/Computer_Science/Databases_and_Data_Structures/Database_Design_2e_(Watt)/01%3A_Chapters/1.01%3A_Before_the_Advent_of_Database_SystemsThe difficulties that arise from using the file-based system have prompted the development of a new approach in managing large amounts of organizational information called the database approach. With ...The difficulties that arise from using the file-based system have prompted the development of a new approach in managing large amounts of organizational information called the database approach. With this understanding of data, we can start to see how a tool with the capacity to store a collection of data and organize it, conduct a rapid search, retrieve and process, might make a difference to how we can use data.
- https://eng.libretexts.org/Bookshelves/Computer_Science/Databases_and_Data_Structures/Database_Design_2e_(Watt)/00%3A_Front_Matter/06%3A_AcknowledgementsI would like to thank Nguyen Kim Anh of OpenStax College, for her contribution of database models and the relational design sections. I would also like to thank my many students over the years and a s...I would like to thank Nguyen Kim Anh of OpenStax College, for her contribution of database models and the relational design sections. I would also like to thank my many students over the years and a special instructor, Mitra Ramkay (BCIT). I would like to thank the many people who helped in this edition including my students at Douglas College and my colleague Ms. We would like to particularly thank Lauri Aesoph at BCcampus for her perseverance and hard work while editing the book.
- https://eng.libretexts.org/Bookshelves/Computer_Science/Databases_and_Data_Structures/Database_Design_2e_(Watt)/01%3A_Chapters/1.19%3A_Appendix_C_-_SQL_Lab_with_SolutionUse the script OrdersAndData.sql that creates the tables and adds the data for the Orders and Data ERD in Figure C.1. Show the CREATE TABLE statements with the modifications including the constraints ...Use the script OrdersAndData.sql that creates the tables and adds the data for the Orders and Data ERD in Figure C.1. Show the CREATE TABLE statements with the modifications including the constraints given in step 3. Show the CREATE TABLE statement and the INSERT statements for the five employees. Show the script for creating the table, setting constraints and adding employees. Using the UPDATE statement, add the total sale for each order based on the order details table.
- https://eng.libretexts.org/Bookshelves/Computer_Science/Databases_and_Data_Structures/Database_Design_2e_(Watt)/01%3A_Chapters/1.18%3A_Appendix_B_-_Sample_ERD_ExercisesA customer may come in just to have his or her car serviced; that is, a customer need not buy a car to be classified as a customer. When a customer takes one or more cars in for repair or service, one...A customer may come in just to have his or her car serviced; that is, a customer need not buy a car to be classified as a customer. When a customer takes one or more cars in for repair or service, one service ticket is written for each car. A car brought in for service can be worked on by many mechanics, and each mechanic may work on many cars. A car that is serviced may or may not need parts (e.g., adjusting a carburetor or cleaning a fuel injector nozzle does not require providing new parts).
