...one (1) 4 Entity-Relationship Diagram Two (2) 5 Entity-Relationship Diagram Three(3) 5 NORMALIZATION 7 Normalization Process 7 Un-normalized data 8 1st Normal Form 8 2nd Normal Form 9 3rd Normal Form 9 Normalized Tables 10 INTRODUCTION Planning a wedding is one of the most exciting and most stressful events in one’s lifetime and in Planning this there is a number of factors that need to be considered such as the guest list, venues, and suppliers. Hence on the quest to organize the scheduling and selection of activities for planning Of weddings a database System will be designed to accommodate its operation, providing a high degree of Usability and efficiency for the people using the application within the company. The database would be built in Oracle having forms that provide at least the minimum basic CRUD (Create, Read, Update, and Delete) functions and the following are the specific forms required; Basic wedding detail form, Supplier type form, Event type form, Supplier detail form, Event detail Form along with the advanced forms such as Wedding event schedule form, wedding event guest form, wedding event supplies and company work schedule summary. The system will be constructed from a number of normalized tables that will be used to construct the Forms and an entity relationship diagram will be formed showing relationships between entities and There attributes. More specifically, the system would show which client...
Words: 1357 - Pages: 6
...Form (Rev. January 2011) Department of the Treasury Internal Revenue Service 8822 Change of Address ▶ ▶ Please type or print. ▶ OMB No. 1545-1163 See instructions on back. Do not attach this form to your return. Before you begin: If you are changing both your home and business address, use a separate Form 8822 to report each change. Part I Complete This Part To Change Your Home Mailing Address Check all boxes this change affects: 1 Individual income tax returns (Forms 1040, 1040A, 1040EZ, 1040NR, etc.) ▶ If your last return was a joint return and you are now establishing a residence separate ▶ from the spouse with whom you filed that return, check here . . . . . . . . 2 Gift, estate, or generation-skipping transfer tax returns (Forms 706, 709, etc.) ▶ For Forms 706 and 706-NA, enter the decedent’s name and social security number below. ▶ Decedent’s name ▶ Social security number 3a Your name (first name, initial, and last name) 3b Lisandra Sanchez Your social security number 592894728 4a Spouse’s name (first name, initial, and last name) 4b Spouse’s social security number 5a Your prior name. See instructions. 5b Spouse’s prior name. See instructions. 6a Old address (no., street, apt no., city or town, state, and ZIP code). If a P.O. box or foreign address, see instructions. 16950 N Bay Rd # 514, Sunny Isles Beach, Florida 33160 6b Spouse’s old address, if different from line 6a (no., street, apt no.,...
Words: 1754 - Pages: 8
...Department of Information Studies University College London Module INST2005 Database Systems Normalisation Exercises 1: Answer notes 1) Unnormalised Title Author Publisher Publisher's address *Book number Borrower number Borrower name Borrower address Loan date Return date 1NF *Book number Title Author Publisher Publisher's address Borrower number Borrower name Borrower address Loan date Return date 2NF *Book number Title Author Publisher Publisher's address Borrower number Borrower name Borrower address Loan date Return date 3NF *Book number Title Borrower number Loan date Title Author Publisher Publisher Publisher's address Borrower number Borrower name Borrower address Loan date Return date Queries: Is title unique? If not what should we do? *Use ISBN13? Is the return date solely dependent on the loan date? Is it logical to keep the "loan record" in the copy? Do we want to store old loan info? Will this structure support/allow us to easily fulfil our purpose? Further exercises: try developing an e-r diagram based on the 3NF data; consider some of the ideas mentioned, incorporate some changes, and reapply the normalisation process. 2) Unnormalised Student no Student name Prog. Name Prog. Length Module code Module name Module tutor 1NF Student no Student name Prog. Name Prog. Length 2NF Student no Student name Prog. Name Prog. Length 3NF Student no Student name Prog. Name Student no Module code Module name Module tutor Student no Module code Module code Module name...
Words: 1433 - Pages: 6
...Application For Naturalization USCIS Form N-400 Department of Homeland Security U.S. Citizenship and Immigration Services For USCIS Use Only Date Stamp Receipt OMB No. 1615-0052 Expires 09/30/2015 Action Block Remarks Type or print all your answers in black ink. Type or print "N/A" if an item is not applicable or the answer is "none" unless otherwise indicated. Failure to answer all of the questions may delay USCIS processing your Form N-400. NOTE: You must complete Parts 1. - 14. Part 1. Information About Your Eligibility (Check only one box or your Form N-400 may be delayed) Enter Your 9 Digit A-Number: ► A- You are at least 18 years old and 1. Have been a Permanent Resident of the United States for at least 5 years. 2. Have been a Permanent Resident of the United States for at least 3 years. In addition, you have been married to and living with the same U.S. citizen spouse for the last 3 years, and your spouse has been a U.S. citizen for the last 3 years at the time of filing your Form N-400. 3. Are a Permanent Resident of the United States, and you are the spouse of a U.S. citizen, and your U.S. citizen spouse is regularly engaged in specified employment abroad. (Section 319(b) of the Immigration and Nationality Act) 4. Are applying on the basis of qualifying military service. 5. Other (explain): Part 2. Information About You (Person applying for naturalization) 1. Your Current Legal Name (do...
Words: 2108 - Pages: 9
...Application through Post to UIDAI: 1. Name 2. Address 3. Date of Birth 4. Gender 5. Mobile Number Maximum permissible update request for each resident till March 2014 is limited to four. Resident has the option to submit application online and send the supporting documents through Post. For this Resident must visit the online portal for Update request submission and follow the instructions on portal. Else Resident can fill Aadhaar Update Form and send the hard copy of the filled form along with documents to UIDAI. The process for request through post is as follows: 1. Fill in the complete Aadhaar Data Update/Correction Form and sign off. 2. Depending on the field to be updated, attach self attested supporting documents as per the Valid Documents List attached in Annexure I. a. Name Correction/Update – Requires PoI listed in “Supported Proof of Identity (PoI) Documents Containing Name and Photo for Name Corrections/Update” b. Date of Birth Correction – Requires DoB listed in “Supported Proof of Date of Birth (DoB) Documents” c. Address Corrections/Change – Requires PoA listed in “Supported Proof of Address (PoA) Documents Containing Name and Address” 3. Review the data entered for correctness and completeness in English as well as local language. UIDAI will not make any corrections to the information in your request. 4. Mention your Aadhaar Number on all document copies. 5. Send the Form along with the supporting documents to one of the address given in Annexure II. Mark the envelope...
Words: 1394 - Pages: 6
...Health Information Form-for Adults DO NOT USE YOUR OWN INFORMATION A. Identification Name (Last) VALEZ JOHN B. Emergency Contacts (First) (Middle) GEORGE In Case of Emergency, Notify: Primary Contact Name VALEZ HOLLY MAY Maiden Name N/A Primary Address 5432 RESIDENT DRIVE City HOMESTED Relationship SPOUSE State FL Zip 33371 Country USA Alternate Address N/A City Address SAME City State Zip Code Country Home Phone (123) 555-1212 Work Phone (123) 555-0001 Cell Phone (123) 555-2219 State Zip Code Home Phone SAME Country Work Phone (123) 555- 9925 Email Address myemail@gmail.com Date of Birth 08/19/1966 Height 6’3” Sex: X Male Weight 225 LB Race HISPANIC Eye Color BLUE Female Hair Color BROWN Birthmark/Scars NONE Blood/RH Type O+ Cell Phone (123) 555- 5533 Email Address heremail@gmail.com In Case of Emergency, Notify: Secondary Contact Name (last) VALEZ Name (middle) Name (first) JOSE Relationship BROTHER Special Conditions Marital Status M Address 9959 CIRCLE STREET Occupation GROCERY MANAGER City DENVER Company Name PUBLIX SUPER MARKET Home Phone (861) 382-5423 Work Phone Cell Phone Email Address City HOMESTED State FL Phone Number (123) 555-9867 Zip Code 33371 Country USA Languages Spoken ENGLISH/SPANISH Primary Health Insurance Carrier BCBS OF FLORIDA Secondary Health Insurance Carrier N/A Policy Number 526-9887598PUBLIX Policy Number State CO Zip Code 87598 Country USA In Case of Emergency, Notify: Medical Contact Doctor...
Words: 1145 - Pages: 5
...(a) (b) (c) (d) (e) (f) (g) (h) Form to be filled legibly in BLOCK LETTERS and in BLACK INK only. Mention 10 digit PAN correctly. 'Individual' applicant to affix a recent colour photograph (size 3.5 cm x 2.5 cm) in the space provided on the form. The pho tograph should not be stapled or clipped to the form. The clarity of image on PAN card will depend on the quality and clarity of photograph affixed on the form. Signature / Left hand thumb impression should be within the box provided in the form. The signature should not be on the ph otograph. If there is any mark on the photograph such that it hinders the clear visibility of the face of the applicant, the application will not be accepted. Thumb impression, if used, should be attested by a Magistrate or a Notary Public or a Gazetted Officer under official seal a nd stamp. For issue of new PAN card without any changes - In case you have a PAN but no PAN card and wish to get a PAN card, fill all columns of the form but do not tick any of the boxes on the left margin. In case of loss of PAN card, a copy of FIR may be submitted along with the form. For changes or correction in PAN data, fill all columns of the form and tick box on left margin of appropriate row where change/correction is required. Having or using more than one PAN is illegal. If you possess more than one PAN, kindly fill the details in Item No.10 of this form and surrender the same. Item Details Full Name Guidelines for filling the form Individuals must state fully...
Words: 2147 - Pages: 9
... A1 – a) Below is the data model for 2nd Normal form for travel company. Their table name and column names are mentioned in the table. SalesPersonDetails EmployeeId FirstName LastName ToursSold Integer Text Text Integer CustomersData CustomerID CustomerName Address City State ZipCode Integer Text Text Text Text Text CustomerTourDetails CustomerID TourID Numberof PersonsinTour TotalAmount Paid Integer Integer Integer Integer TourDetails TourSeason TourID TourRates PerPerson Date Integer Integer Integer A 1 – b) Table Name: SalesPerson Attributes: EmployeeID, FirstName, LastName, ToursSold Table Name: CustomersData Attributes: CustomerID, CustomerName, Address, city, State, ZipCode For More Information hit Purchase Button to Get Your Assignment CIS 515 Week 5 Assignment https://hwguiders.com/downloads/cis-515-week-5-assignment/ Tours Company System – Database Implementation Your Name Your College Your University Date A1 – a) Below is the data model for 2nd Normal form for travel company. Their table name and column names are mentioned in the table. SalesPersonDetails EmployeeId FirstName LastName ToursSold Integer Text Text Integer CustomersData CustomerID CustomerName Address City State ZipCode Integer Text Text Text Text Text ...
Words: 1984 - Pages: 8
... A1 – a) Below is the data model for 2nd Normal form for travel company. Their table name and column names are mentioned in the table. SalesPersonDetails EmployeeId FirstName LastName ToursSold Integer Text Text Integer CustomersData CustomerID CustomerName Address City State ZipCode Integer Text Text Text Text Text CustomerTourDetails CustomerID TourID Numberof PersonsinTour TotalAmount Paid Integer Integer Integer Integer TourDetails TourSeason TourID TourRates PerPerson Date Integer Integer Integer A 1 – b) Table Name: SalesPerson Attributes: EmployeeID, FirstName, LastName, ToursSold Table Name: CustomersData Attributes: CustomerID, CustomerName, Address, city, State, ZipCode For More Information hit Purchase Button to Get Your Assignment CIS 515 Week 5 Assignment https://hwguiders.com/downloads/cis-515-week-5-assignment/ Tours Company System – Database Implementation Your Name Your College Your University Date A1 – a) Below is the data model for 2nd Normal form for travel company. Their table name and column names are mentioned in the table. SalesPersonDetails EmployeeId FirstName LastName ToursSold Integer Text Text Integer CustomersData CustomerID CustomerName Address City State ZipCode Integer Text Text Text Text Text ...
Words: 1984 - Pages: 8
...For Office Use only Transaction ID: 2312308/MBBS ALIGARH MUSLIM UNIVERSITY Session: 2013-14 Application Form for Admission to M.B.B.S./B.D.S. FACULTY OF MEDICINE Affix (don't staple) Self Attested Photograph of size 2.5 x 3cm Bank: STATE BANK OF INDIA, DD/CR No.: 796772, Date: 2013-03-19, Amount: 500 Nationality: INDIAN Order of Preference of Branches: __________________________________________________________________________________________________ 1. MBBS 2. BDSB 3. -- 4. -- 5. -- 6. -- 7. -- 8. -- 9. -Preference for Test Centres: __________________________________________________________________________________________________ 1. ALIGARH 2. LUCKNOW Personal Details: __________________________________________________________________________________________________ Name: MOHSIN BEIG Date of Birth: 02-03-1996 Gender: MALE Religion: ISLAM Father's Name: KHALID BEIG Mother's Name: SHAHEEN BEIG Parent's/Guardian's Monthly Income: 20000 Rural/Urban: URBAN Details of Qualifying Examination: Status & Special Categories: __________________________________________________________________________________________________ Examination: INTERMEDIATE Roll No.: Year of Passing/Appearing: 2013 Board/Univ.: 521 Marks Obt./Max. Marks: / Remarks (if any): RA Status: EXTERNAL Enrolment No.: Hall: Special Categories: 1. -- 2. -- 3. -- Course(s) Studied/Studying other than Qualifying Examination (Starting from the latest): ______________________________________________...
Words: 899 - Pages: 4
...B. APPLICATION FOR ACCREDITATION OF NEW AND RENEWING SCHOOL ORGANIZATIONS (Approved by the BOR March 4, 2011) Instructions: 1) Download & print SO Application pg. 1 to 3 and SO Form A & B up to F 2) Fill up the Forms & follow the Procedure 3) Submit the accomplished Application for Accreditation to: a) Office of Student Affairs (for University Organizations) b) College Committee for Student Organizations (CCSO) in your respective colleges (for College Organizations) ( Rev. SO App p. 1 Mar 11/eij) West Visayas State University OFFICE OF STUDENT AFFAIRS La Paz, Iloilo City Application for Accreditation of New and Renewing School Organizations CHECKLIST OF DOCUMENTS TO BE SUBMITTED FOR OSA/CCSO (to be accomplished in 2 sets) 1. Application for Accreditation with Adviser’s Consent 2. Organizational Profile (Forms C) 3. List of officers for the academic year including the course & year level, home address, contact number, recent 1x1 picture and signature 4. List of members with I.D. No., course & year level with signature 5. Accomplishment Report of projects & activities during the previous academic year including awards and recognition received These must be accompanied with supporting documents such as approved permits, pictures, certificates & write ups in school paper 6. Approved Financial Report for the previous academic year 7. Calendar of Activities for the incoming school year with planned activities, date schedule, venue & other important information 8...
Words: 1958 - Pages: 8
...Individual Report 1. A. 158.175.160.0 is assigned to my group, it is a class B of network address. Based on the IP address that have assigned to my group (158.175.160.0) which is a class B IP address, the first pair of octet is for network and the second pair of octet if for the hosts. The number of octets in the network is defined by 214 which means there are total 16384 number of network and for the number of octets in the host is defined by 216 which means there are total 65536 number of hosts. Classful addressing is a system that classified them into 5 classes which is A, B, C, D and E. the most frequently used address is class A, B, and C. For the class D it is for the purpose of Multicast and it is very rare in use, and for class E is...
Words: 1442 - Pages: 6
...Determine Network Addresses Part 3: Apply Network Address Calculations Background / Scenario Every IPv4 address is comprised of two parts: a network portion and a host portion. The network portion of an address is the same for all devices that reside in the same network. The host portion identifies a specific host within a given network. The subnet mask is used to determine the network portion of an IP address. Devices on the same network can communicate directly; devices on different networks require an intermediary Layer 3 device, such as a router, to communicate. To understand the operation of devices on a network, we need to look at addresses the way devices do—in binary notation. To do this, we must convert the dotted decimal form of an IP address and its subnet mask to binary notation. After this has been done, we can use the bitwise ANDing operation to determine the network address. This lab provides instructions on how to determine the network and host portion of IP addresses by converting addresses and subnet masks from dotted decimal to binary, and then using the bitwise ANDing operation. You will then apply this information to identify addresses in the network. Convert IPv4 Addresses from Dotted Decimal to Binary In Part 1, you will convert decimal numbers to their binary equivalent. After you have mastered this activity, you will convert IPv4 addresses and subnet masks from dotted decimal to their binary form. Convert decimal numbers to their binary equivalent...
Words: 1123 - Pages: 5
...| Early Childhood Qualifications Fund | | Application Form | Personal Information | Title: Family Name: Given Names: | | Date of Birth: / / Gender: Male Female | | Are you an Australian citizen or a permanent resident of Australia? Yes No | | Are you of Aboriginal or Torres Strait Islander origin? Yes No | | Do you speak a language other than English at home Yes No No | | If yes, what language do you speak? | Address and Contact Information | Postal Address | | Address: | | Suburb: State: Postcode: | | Permanent Address Same as above | | Address: | | Suburb: State: Postcode: | | Home Telephone: Work Telephone: | | Mobile Telephone: | | Email Address: | Details of Current Employment | Current Position Title (e.g. early childhood educator): | | What is your employment status: permanent full-time permanent part-time contract casual | | Name of Service: | | Service Telephone Number: | | Service Email Address: | | Service Address: | | Name and Title of Contact Person at your service(e.g. centre coordinator) | Application Form (cont.) | Details of Employment | What date did you commence your current position? | | How long have you worked in your current position? | | How many hours per week do you work at your current service? | | Over your entire working history...
Words: 1185 - Pages: 5
...Remember to include your e-mail address when completing this transmittal form. Providing your e-mail address allows us to notify you via e-mail when we receive your filing and when we take action on your filing. Please enter your e-mail address on the line below. Thank you. E-Mail: _____________________________________________________________________ NOTICE TO APPLICANT: PRINT PLAINLY OR TYPE REMAINDER OF THIS FORM 1. LLC Name Reservation Number (if one has been obtained; if articles are being filed without prior reservation, leave this line blank) LLC Name (List exactly as it appears in articles) 2. Kaiyu Ji Name of person filing articles (certificate will be mailed to this person, at address below) 6787791234 Telephone Number 123 Columbia Dr Address Carrollton City 3. GA State 30117 Zip Code 100 Maple St Principal Office Mailing Address of LLC (Unlike registered office address, this may be a post office box) Carrollton City 4. Name of LLC’s Registered Agent in Georgia GA State 30118 Zip Code Registered Office Street Address of LLC in Georgia (Post office box or mail drop not acceptable for registered office address) City 5. Name and Address of each organizer Organizer Organizer 6. County GA State Zip Code (Attach additional sheets if necessary) Address Address City City State State Zip Code Zip Code Mail the following items to the Secretary of State at the above address: 1) This transmittal form 2) Original and one copy of...
Words: 327 - Pages: 2
