...schedule routine maintenance, track parts inventory which helps prevent slowdowns in production. Parts Inventory Purchases Transaction ID Auto Number Primary Key Purchase Date Date/Time Purchase Price Currency Quantity Numeric Value Rationale of primary key – The Transaction ID should be a unique number which can be tracked back to the parts inventory purchase table and will make a perfect Primary Key. Rationale for foreign key 1 – There will be no foreign keys in this table as no other table for the Fleet Truck Maintenance will be using one of the values as a Primary Key. Rationale for foreign key 2 – There will be no foreign keys in this table as no other table for the Fleet Truck Maintenance will be using one of the values as a Primary Key Parts Inventory Issues Transaction ID Auto Number Foreign Key 1 Issue Date Date/Time Purchase Price Currency Quantity Numeric Value Parts Inventory ID Auto Number Primary Key Rationale of primary key – The parts inventory ID will be used as the primary key for the Parts inventory issues as it will be an auto number. The transaction ID can’t be used as it is already a Primary Key for another Table. Rationale for foreign key 1 – The Transaction ID will be Foreign Key 1 as it is being used as a Primary Key for the parts inventory table. Rationale for foreign key 2 – There will be no foreign key2 in this table as no other table for the Fleet Truck Maintenance...
Words: 1514 - Pages: 7
...Varchar(20) Int Int Int Key Type PK FK FK FK Allows Nulls MakeModel Cols ID Year MakeID ModelID Type Int Int(4) Int Int Key Type PK FK FK Allows Nulls Makes Cols ID Make Type Int Text Key Type PK Allows Nulls Models Cols ID Model Type Int Text Key Type PK Allows Nulls TruckMaintenanceHistroy Cols ID PerformedOn PerformedBy MaintenanceSheetID Type Int DateTime Int Int Key Type PK FK FK Allows Nulls TruckMaintenanceSheets Cols ID Status Type Int Int Key Type PK FK Allows Nulls TractorUnitPerformed EngineCompartmentPerformed CabinPerformed AirDamPerformed AirTanksPerformed FuleTanksPerformed WheelsPerformed BrakesPerformed AxelPerformed Bool Bool Bool Bool Bool Bool Bool Bool Bool Trailers Cols VIN TypeID LastMaintenanceID NextScheduledMaintenance Type Varchar(20) Int Int Int Key Type PK FK FK FK Allows Nulls Yes Yes TrailerTypes Cols ID Name TypeSpecID Type Int Text Int Key Type PK FK Allows Nulls TypeSpecs Cols ID Dimension_L Dimension_W Dimension_H LoadCapacity Weight Type Int Varchar(6) Varchar(6) Varchar(6) Varchar(6) Varchar(6) Key Type PK Allows Nulls TrailerMaintenanceHistroy Cols ID PerformedOn Type Int DateTime Key Type PK Allows Nulls PerformedBy MaintenanceSheetID Int Int FK FK TrailerMaintenanceSheets Cols ID Status FifthWheelCouplingPerformed CargoSpacePerformed LoadingDoorPerformed LandingGearPerformed WheelsPerformed BrakesPerformed AxelPerformed Type Int Int Bool Bool Bool Bool Bool Bool Bool Key Type PK FK Allows...
Words: 360 - Pages: 2
...Customer( customer-id Int NOT NULL IDENTITY (1001,1), name VarChar(30) NOT NULL, contact Char(8) NOT NULL, email VarChar(25) NULL, address VarChar(60) NOT NULL, CONSTRAINT Customer_PK PRIMARY KEY (customer-id), CONSTRAINT Valid_Contact CHECK (contact LIKE ‘[6|8|9] [0-9] [0-9] [0-9] [0-9] [0-9] [0-9] [0-9]) ); (ii) CREATE TABLE Renovation( renovation-id Char(6) NOT NULL, renovation-site VarChar(30) NOT NULL, start-date Date NOT NULL, expected-end-date Date NOT NULL, customer-id Int NOT NULL, CONSTRAINT Renovation_PK PRIMARY KEY (renovation-id), CONSTRAINT Renovation_AK1 UNIQUE(renovation-site, start-date), CONSTRAINT Customer_FK FOREIGN KEY(customer-id), REFERENCES Customer(customer-id) ON UPDATE NO ACTION ON DELETE NO ACTION CONSTRAINT Valid_Reno_ID CHECK (renovation-id LIKE ‘[C|R] [0-9] [0-9] [0-9] [0-9] [0-9]), CONSTRAINT DateCheck CHECK (expected-end-date > start-date) ); (iii) CREATE TABLE Work( work-id Int NOT NULL IDENTITY (1001,1), renovation-id Char(6) NOT NULL, job-description VarChar(25) NOT NULL, category VarChar(10) NOT NULL DEFAULT ‘general’, cost Numeric(9,2) NOT NULL, CONSTRAINT Work_PK PRIMARY KEY (work-id), CONSTRAINT Renovation_FK FOREIGN KEY (renovation-id), REFERENCES Renovation(renovation-id) ON UPDATE NO...
Words: 869 - Pages: 4
...the agency has an arrangement to pick & drop its customers who arrive in different locations. 6.19: A 1:1 strong entity relationship can be denoted by assigning one of the primary keys as a foreign key in anyone of the two entities. From the above example, every CHAUFFEUR must have a VEHICLE, and every VEHICLE must be assigned to a CHAUFFEUR. This relationship is a 1:1 strong entity relationship. This relationship can be denoted by either assigning the primary key of CHAUFFEUR in VEHICLE as a foreign key, or by assigning the primary key of VEHICLE in CHAUFFEUR as a foreign key. 6.20: A 1:N strong entity relationship can be denoted by assigning the primary key of the parent in child entity as a foreign key. From the above example, every CUSTOMER must be assigned to a CHAUFFEUR, but there can be CHAUFFEUR who has no CUSTOMER assigned. This relationship is an 1:N, M-O and a 1:N strong entity relationship. The relationship can be denoted by assigning the primary key of CHAUFFEUR in CUSTOMER as a foreign key. 6.21: A N:M strong entity relationship can be denoted by assigning the primary key of every entity into a separate table making two 1:N relationships, the resulting table is intersection table. An intersection table will have a composite primary key comprising of the two foreign keys in each row. From the above example, every CUSTOMER may have interest in one or more PACKAGES, and each PACKAGE may be explained to every CUSTOMER. But, CUSTOMER may be inquiring...
Words: 1348 - Pages: 6
...Data Management Project – Pharmacy Management System Requirement Analysis Background At the pharmacy centre of Queens Hospital, New York, pharmacists dispenses the drugs prescribed by the physician to the patients. These drugs were prescribed by the physician in written prescription form. All the prescriptions along with the dispensing information were maintained in the form of written records. These written records were used to track the medical history of the patients. It was very difficult to maintain these details in the form of written records and retrieve them whenever needed. So, the Queens Hospital officials contacted us to give a proposal for work to be done on an electronic database. On December 5 2014, a meeting was held with the health care professionals of Queens Hospital. During the meeting we were able to obtain enough information to provide the health care professionals of Queens Hospital with a Requirements Document. This document outlines the user requirements for a proposed electronic pharmacy records tracking system. Requirements General Constraints, Assumptions, Dependencies, and Guidelines The following items present the general constraints, assumptions, dependencies, and guidelines that are required upon the implementation of the electronic pharmacy record database. * A general knowledge of basic computer skills is necessary to use this product. * Most of the times health care professionals doesn’t have core knowledge on computers. So...
Words: 3164 - Pages: 13
...Trucking Database (HTD) is normalizing up to 3NF level. The first step in normalizing is to fine the candidate key in the database. The “Employer ID Number”, “Driver Log ID”, and “Citation Number” are candidate keys in the database. First Normal Form (1NF) values of a database are: • Each column must have a unique name. • The order of the rows and columns doesn’t matter. • Each column must have a single data type. • No two rows can contain identical values. • Each column must contain a single value. • Columns cannot contain repeating groups. The tables in HTD consists unique names and each column has a single data type. Each table consists of primary key, which makes the row contain identical values. The HTD passes all the requirement of firs normal form. Second Normal Form (2NF) form with two conditions: • The table is in 1NF. • All the non key fields depend upon on all the key fields. All the three tables are depending upon the primary key or key fields; this makes the table to update anomalies. The HTD passes the requirement of second normal form Third Normal Form (3NF) form with two conditions: • The table is in 1NF. • It contains no transitive dependencies. A transitive dependency is when one non-key field’s value depends on another non-key field’s value. The drives log table need to driver log key to form 3NF, because Employee ID, Date, and Tractor ID are inter dependent. The other two table are depend upon the primary...
Words: 257 - Pages: 2
...SQL Tutorial SQL TUTORIAL Simply Easy Learning by tutorialspoint.com tutorialspoint.com i ABOUT THE TUTORIAL SQL Tutorial SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language. This tutorial will give you quick start with SQL. Audience This reference has been prepared for the beginners to help them understand the basic to advanced concepts related to SQL languages. Prerequisites Before you start doing practice with various types of examples given in this reference, I'm making an assumption that you are already aware about what is database, especially RDBMS and what is a computer programming language. Copyright & Disclaimer Notice All the content and graphics on this tutorial are the property of tutorialspoint.com. Any content from tutorialspoint.com or this tutorial may not be redistributed or reproduced in any way, shape, or form without the written permission of tutorialspoint.com. Failure to do so is a violation of copyright laws. This tutorial may contain inaccuracies or errors and tutorialspoint provides no guarantee regarding the accuracy of the site or its contents including this tutorial. If you discover that the tutorialspoint.com site or this tutorial content contains some errors, please contact us at webmaster@tutorialspoint.com TUTORIALS POINT Simply Easy Learning Table of Content SQL Tutorial .................................................................
Words: 39505 - Pages: 159
...SQL Tutorial SQL TUTORIAL Simply Easy Learning by tutorialspoint.com tutorialspoint.com i ABOUT THE TUTORIAL SQL Tutorial SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language. This tutorial will give you quick start with SQL. Audience This reference has been prepared for the beginners to help them understand the basic to advanced concepts related to SQL languages. Prerequisites Before you start doing practice with various types of examples given in this reference, I'm making an assumption that you are already aware about what is database, especially RDBMS and what is a computer programming language. Copyright & Disclaimer Notice All the content and graphics on this tutorial are the property of tutorialspoint.com. Any content from tutorialspoint.com or this tutorial may not be redistributed or reproduced in any way, shape, or form without the written permission of tutorialspoint.com. Failure to do so is a violation of copyright laws. This tutorial may contain inaccuracies or errors and tutorialspoint provides no guarantee regarding the accuracy of the site or its contents including this tutorial. If you discover that the tutorialspoint.com site or this tutorial content contains some errors, please contact us at webmaster@tutorialspoint.com TUTORIALS POINT Simply Easy Learning Table of Content SQL Tutorial ......................................
Words: 38789 - Pages: 156
...Can represent all kinds of information Based on Math (relations) Natural to people Relatively simple p We know how to implement it fast 4 Motivating Example • Make a list of students in the class, keeping their ID, name and phone number 5 Motivating Example • Make a list of students in the class, keeping their ID, name and phone number • You’d probably come up with something like this: p y p g ID xx yy Name Mike Mik Elisa Phone 111 222 • This is the basic structure of the relational model, a table or relation 6 Extra Assumptions • You would not repeat the same row twice • No two rows have the same ID, but they may have the same name and phone number p ID xx yy Name Mike Mik Elisa Phone 111 222 • ID would be the PRIMARY KEY (PK). 7 Now add emails … (many!) • Now you need to add the emails of each student, but you do not know how many emails • Can you come up with a solution? Try it … y p y 8 Many Fields y • Could come up with something like this ID xx yy Name Mike Elisa Phone 111 222 Email1 bad bad Email2 idea idea • Above would not work very well. How many fields? – Wasted space – What if a student has more emails? – How to process it in my program? 9 Un normalized Un-normalized • Could also try this: ID xx xx yy Name Mike Mike Elisa...
Words: 2276 - Pages: 10
...CISN 351: Review Questions Chapter 2 2.1 What is a business intelligence (BI) system? 2.2 What is an ad-hoc query? 2.3 What does SQL stand for, and what is SQL? 2.4 What does SKU stand for? What is an SKU? 2.5 Summarize how data were altered and filtered in creating the Cape Codd data extraction. 2.6 Explain, in general terms, the relationships among the RETAIL_ORDER, ORDER_ITEM, and SKU_DATA tables. 2.7 Summarize the background of SQL. 2.8 What is SQL-92? How does it relate to SQL statements in this chapter? 2.9 What features have been added to SQL in versions subsequent to the SQL-92? 2.10 Why is SQL described as a data sublanguage? 2.11 What does DML stand for? What are DML statements? 2.12 What does DDL stand for? What are DDL statements? 2.13 What is the SQL SELECT /FROM/WHERE framework? 2.14 Explain how Access uses SQL. 2.15 Explain how enterprise-class DBMS products use SQL. 2.16 There is an intentional flaw in the design of the INVENTORY table used in these exercises. This flaw was purposely included in the INVENTORY tables so that you can answer some of the following questions using only that table. Compare the SKU and INVENTORY tables, and determine what design flaw is included in INVENTORY. Specifically, why did we include it? 2.17 Write an SQL statement to display SKU and SKU_Description. 2.18 Write an SQL statement to display SKU_Description...
Words: 7421 - Pages: 30
...flagging the member if the book is returned late. Once flagged, the member will have to pay RM1 for every one day after the due date. For each Book, they will be placed in a specific Location, based on a book category. A Location, which means a section in the library, can have many Books. The library management system also keeps track of the library’s Suppliers. These Suppliers can supply many Books to the library. This data is useful for the library to know where specific Books come from, in case of refunds and future purchases. Entities Billing Field Name | Data Type | Description | Field Properties | BillingID (Primary Key) | Short Text | ID number of each Billing | Field Size: 6Default Value: “BL”Validation Rule: LIKE “BL#*”Validation Text: Billing ID must start with “BL” followed by numbers | MemberID (Foreign Key) | Short Text | ID number of Member in charge of settling the Billing | Lookup Row Source: Member | FineAmount |...
Words: 2045 - Pages: 9
...posibilitatea de adauga, modifica sau sterge datele legate de studenti respectand anumite norme de integritate. Fiecare student va avea inregistrate date precum nume,prenume,cnp,data nasterii,gupa din care face parte,anul s.a. . Baza de date ne va oferi posibilitatea de a stoca notele fiecarui student si facultatea din care face parte. Baza de date contine urmatoarele tabele : student, facultate, note si materii. Tabela student contine urmatoarele informatii: id-ul studentului, id-ul facultatii din care face parte,numele, prenumele,cnp-ul, data nasterii, anul si grupa din care face parte. Tabela facultate contine : id-ul facultatii, numele facultatii,adresa si numele decanului. Tabela note contine urmatoarele informatii: id-ul notei, id-ul materiei,id-ul studentului, nota si data in care a fost primita. Tabela materii cotine urmatoarele informatii: id-ul materiei, denumire, an, profersor. Diagrama ERD Crearea tabelelor: Creare tabela studenti: create table studenti( id_stud number(4) not null primary key, - numar din maxim 3 cifre, nenul, cheie primara id_fac number(2) not null, -numar din maxim 2 cifre, nenul nume varchar(20) not null, -maxim 20 de caractere,nenul prenume varchar(20) not null, - maxim 20 de caractere,nenul cnp number(13) not null, -numar din maxim 13 cifre, nenul data_nasterii date not null, -data,nenula an number(1) not...
Words: 1836 - Pages: 8
...Enterprise Architecture Program Key Initiative Overview ® Enterprise Architecture Program Key Initiative Overview Richard Buchanan Research Managing Vice President This overview provides a high-level description of the Enterprise Architecture Program Key Initiative. IT leaders can use this guide to understand what they need to do to prepare for this initiative. Analysis Enterprise architecture (EA) is a strategic planning process that translates an enterprise’s business vision and strategy into effective enterprise change. The EA program institutes a collaborative, shared planning process. EA teams work with business and IT stakeholders to define a future-state vision in terms of requirements, principles and models. They then compare the future-state vision to the current state, identify gaps and plan investments to fill them. EA is not IT-focused, but business-driven and comprehensive. The future-state vision helps coordinate the analysis of—and develop a plan to harmonize—required changes in business functions and processes, information and data provisioning, technology capabilities and application solutions. An effective EA program will help align IT investments with long-term strategy, reduce risk, deliver higher-quality information and engineer adaptive solutions and technical services. Consider these factors to determine your readiness EA planners must charter the program and ensure that senior leaders support it. They must also establish program...
Words: 1919 - Pages: 8
...Chapter 6 Basic data structures A data structure, sometimes called data type, can be thought of as a category of data. Integer is a data category which can only contain integers. String is a data category holding only strings. A data structure not only defines what elements it may contain, it also supports a set of operations on these elements, such as addition or multiplication. Strings and numbers are the core data structures in Python. In this chapter, you’ll see a few more, almost as important, data structures. In the next chapter, you’ll se how you can design your own, customary data structures. The concept of a sequence is so fundamental to programming that I’ve had a very hard time avoiding it so far. And as you, alert and perky, have noticed, I actually haven’t, since I involuntarily had to introduce sequences in Section 4.4 when talking about the for loop. In Python, the word “sequence” covers several phenomena. Strings are sequences of characters, and you heard about those in Chapter 3. In the coming sections, you’ll hear about the two other basic types of sequence supported by Python: Lists and tuples. Later in this chapter, we’ll get around to talking about sets and dictionaries. Strings and integers represent concrete data objects; a string or a number represents true data in itself.1 Lists, tuples and dictionaries are designed to organize other data, to impose structure upon it; they do not necessarily represent true data in their own right. For this reason, they...
Words: 18297 - Pages: 74
...SPRING Link: http://static.springsource.org/spring/docs/2.5.4/reference/index.html Packages to remember: BeanFactory: org.springframework.beans.factory.BeanFactory Interface. XmlBeanFactory: org.springframework.beans.factory.xml.XmlBeanFactory Class. It implements BeanFactory Interface. Application Context: org.springframework.context.ApplicationContext Interface. It is a sub interface of BeanFactory. ClassPathXmlApplicationContext: org.springframework.context.support.ClassPathXmlApplicationContext class. BeanFactory ClassPathXmlApplicationContext XmlBeanFactory ApplicationContext implements extends implements Spring Core Container: Spring core container is an IOC implementation in java. IOC is an architectural pattern describing to have an external entity to wire the objects. Here the wiring is done using dependency injection. IOC pattern describes to have an external entity to perform DI. IOC – Inversion of Control DI – Dependency Injection. Dependency Injection is a mechanism of making the dependencies available to the object. The other 2 approaches to do the same are, 1. Creating the dependencies 2. Pulling the dependencies. In Dependency Injection mechanism the dependencies are pushed into the object. This approach helps us in creating the object more cleanly, as the code for creating or pulling the dependencies is excluded from the object. However identifying the objects in which the DI is to be implemented is a...
Words: 1559 - Pages: 7
