Database Design and Implementation Assignment Example | Topics and Well Written Essays - 2500 words

Database Design and Implementation - Assignment Example Frequently, there are many patrons who borrow copies of books. Each time when a patron borrow a copy of a book, the system automatically generates a transaction identification associated with the borrowing date and due date of the book loan. Each patron has a patron number, patron's name, patron's contact information such as postal address, phone number, and email address. Library system is a simple solution. However, when a library has several branches and all need to share same system, it adds another dimension and hence makes the problem bit more complex. Library is a place where several books are present where patrons can issue them. A table each for storing branch, patron, and book details are needed. An additional table is needed to store list of book authors as there can be multiple authors of a book. As defined in problem several copies of book can be present in one or different branches of library. This adds need of another table which can store details of copies of a book. Apart from these two additional tables are needed to store patron book issue history and second to keep track of which branch contains which copies of book. In all seven different tables are needed to store information per mentioned problem. ER Diagram section shows various tables and relationships between them. Library - There are several branches in a library system, and... The branch number is a unique identifier for each branch. Book - Each book has a book number, title, the number of pages of the books, the name of the publisher, the year of publishing, and list of authors of the book. Patron - A patron borrow a copy of a book. Each patron has a patron number, patron's name, patron's contact information such as postal address, phone number, and email address. Copy - Each library branch owns a large volume of copies of various books, and each copy of a book has a copy number and associated cost. CSDL Schema : LIBRARY Entity: BRANCH Attributes: BRANCHNUMBER: NUMBER(10,0) NAME: VARCHAR2(50) LOCATION: VARCHAR2(50) PHONENUMBER: NUMBER(10,0) Identifiers: BRANCHNUMBER Entity: BOOK Attributes: BOOKNUMBER: NUMBER(10,0) TITLE: VARCHAR2(100) PAGECOUNT: NUMBER(10,0) PUBLISHERNAME: VARCHAR2(50) YEAR: NUMBER(4,0) (1, N) AUTHORNAME: VARCHAR2(50) Identifiers: BOOKNUMBER Entity: COPY Attributes: COPYNUMBER: NUMBER(10,0) COST: NUMBER(10,2) Identifiers: COPYNUMBER Entity: PATRON Attributes: PATRONID: NUMBER(10,0) NAME: VARCHAR2(50) ADDRESS: VARCHAR2(100) PHONE: NUMBER(10,0) EMAIL: VARCHAR2(30) Identifiers: PATRONID Entity: TRANSACTION Attributes: TRANSACTIONID: NUMBER(10,0) BORROWDATE: DATE DUEDATE: DATE Identifiers: TRANSACTIONID Relationship: OWNS Connected Entities: (1,n) BRANCH (1,n) COPY ER Diagram DB Creation Scripts CREATE TABLE BRANCH ( BRANCHNUMBER NUMBER(10,0) NOT NULL, NAME VARCHAR2(50) NOT NULL,

Mexican Immigration and American Identity Essay

Mexican Immigration and American Identity - Essay Example According to the author, even though other values and principles of non-Protestant immigrants have helped to shape and modified this concept, most Americans accept these basic elements of an Anglo-Protestant culture as the key defining elements of their national identity. Yet, the author states that in the last decades of the 20th century, this culture has been challenged by a context of globalization and ideas of multiculturalism and diversity. The rise of groups that focus on race, ethnicity, and gender over a more general national identity are regarded as a threat to 'the country's cultural and political integrity'. Huntington views immigration from Latin America, especially from Mexico, as the single largest threat to the American identity. This due to a combination of six unique characteristics that differentiate contemporary Mexican immigration from past immigrant flows, being contiguity (boarder proximity), scale (steadily increasing numbers), illegality (illegal entry and permanence into the country), regional concentration (particularly concentrated in California and the Southwest), persistence (no signs of decline over the years), and historical presence (historical claim to the US territory). The boarder proximity with Mexico in the Southwest region encourages immigration and illegal entry into the U.S., which results in the steady increase of Mexican immigration throughout the 20th century. Similarly, it increases the concentration of Mexican immigrants in that area of the country and the illegal characteristics of the flow. Since the conditions creating such immigration (economic cond itions of Mexico, boarder proximity, etc) are unlikely to change, the flow is expected to persist. These factors, the author argues, differentiate the Mexican contingent from previous immigrant groups and are likely to hinder the assimilation of Mexicans into the United States culture. One of the author's main arguments defending the poor assimilation of Mexican immigrants into the U.S. society is the persistent use of their native language through successive generations. Huntington admits that statistics on English proficiency and Spanish preservation are limited and ambiguous. Nevertheless, the author insists that particular characteristics of the flow - scale, persistence and concentration - are likely to encourage the perpetuation of Spanish among successive generations of immigrants. Huntington considers that Spanish retention has a negative impact on the assimilation of the new culture even when proficiency in English is achieved. In addition, bilingualism would affect earnings and put English-only families in disadvantage within the job market. Finally, the concentration of Mexicans in certain areas transform portions of the country into bilingual and bicultural areas, reinforcing Mexican values over the traditional Anglo-Protestant values, which, according to the author, threatens the integrity of the nation, possibly dividing the nation 'into a country of two languages and two cultures'. From my point of view, Huntington's concept of the American identity is limited and excludes a great portion of the nation's cultural and ethnic background. The author's