Create an erd that captures all mentioned information

Reference no: EM133196333

Assignment - Client Server Architecture Paper

Question One - There are three main application architectures in use today: server-based architectures, client-based architectures, and client-server architectures. Compare between them by highlighting advantages and disadvantages. Which one is considered the most common architecture?

Question Two - Suppose that you are having a shipping company called ABC which relies on a wide information system to track the location of each shipped item. The system consists of:

(a) Shipped items which are the core of the ABC tracking system, which including: item number (ID), weight, dimensions, destination, and final delivery date.

(b) Shipped items are received into the ABC system at a single retail center. Retail centers are characterized by their number, type and address.

(c) Shipped items make their way to their destination via one or more standard ABC transportation methods. These transportation methods are characterized by a unique tripID, a type, and a DeliveryRoute.

Create an ERD that captures all mentioned information about the ABC system. Be certain to indicate identifiers and cardinality constraints.

Question Three - The university has decided to buy an e-assessment (e-exam) system. This system will be used by students to do their exam. During the requirement gathering the university decided that the system needs to have high standard of performance requirement. Please describes some of the performance requirements should the university apply and which architecture design should be selected and why?

Question Four - Normalize the following unnormalized table using the three normalization rules and describe each step.

Unnormalized table:

Student-ID	Student-Name	Student-City	Student-Code_Area	Instructor-ID	Instructor-Name	Instructor-Office	Course-ID	Course-Name	Grade
S1445	Ahmad	Dammam	03	F12	Abdullah	315	CS140	Programming 1	A
S1446	Samer	Jeddah	05	F93	Nora	116	IT244	Database	B+
S2356	Emad	Riyadh	01	F34	Salem	231	IT243	SAAD	B+
S1445	Ahmad	Dammam	03	F16	Omar	564	CS141	Programming 2	B
S2356	Emad	Riyadh	01	F16	Omar	564	CS141	Programming 2	D
S9511	Khaled	Tabuk	06	F55	Saleh	987	IT455	DSS	A+

Reference no: EM133196333

Questions Cloud

Discuss the purpose of an ethics committee : Discuss the purpose of an ethics committee and its consultative role in the delivery of patient care. Describe what AIDS is and how it is spread

Midwife in the birthing room : Saint Marys University of Minnesota 1) One of your patients is a pregnant woman who is HIV positive and is nervous about having a C-section delivery.

Turn off router before examining for evidence : Innovations Design Academy-Why would you not turn off router before examining it for evidence?

Personal philosophy or mission statement : Sanford Brown College Write a 1-2 page paper detailing your mission statement as a counselor, social worker, or other helping professional. Your mission stateme

Create an erd that captures all mentioned information : Create an ERD that captures all mentioned information about the ABC system. Be certain to indicate identifiers and cardinality constraints

Mobile Web Development Option : ITS 537-University of the Cumberlands-Discuss effective use of screen real estate. Compare and contrast different mobile platforms (i.e. Android, iOS).

How much unemployment is frictional and structural together : How much of the (actual) unemployment is frictional and structural together? University of Illinois at Chicago. EC 121.

Who shows more empathy : University of Maryland Global Campus 1. Do girls speak earlier than boys? If so, why do you think that it the case?

Function of bill of materials in production process : Los Angeles City College-Explain the function of a bill of materials in the production process. Explain the relationship between operations and sequences.

User Account

All Pages