This website uses cookies to ensure you have the best experience. Learn more

Cs251 Fundamantals Of Database Systems Ip 1 5

1710 words - 7 pages

CS251-1301B-03 Fundamentals of Database Systems
Phase 1 -5 Individual Project
March 24th, 2013

Table of Contents
Project Outline 3
Description of the Database Design Life Cycle 4
The Entity Relationship Diagram 7
The Logical Model and Normalization 9
The Microsoft Access Database 11
The Microsoft Access Database Application 14
References: 18

Project Outline

  My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks. We will perform counter sales, contractor and walk-in customer kitchen and bath design, templates, fabrication, installation, and follow-up. To run efficiently (or at all) we must have a ...view middle of the document...

3. Design – The requirements needed for functioning, support, and training are designed in this step. Emphasis is given to the functioning of the system and is produced as a high level guide. All the technical details for developing the system are created in a final system design.
4. Development and Testing – This step involves using the final system design to acquire or develop the system. Testing of units, integration, performance, system, and acceptance are done to ensure system functionality and the sponsor’s requirements and that all segments/structures, communications, applications, procedures, and documentation are in place, tested, and integrated. End users are implemented to verify and thoroughly test that the system functions as required.
5. Implementation – This phase involves installing the system in its planned operating arena, training the users, converting data, turning the system over to the sponsor, and evaluating its performance and processes. System bugs are identified and corrected and planning for sustaining the system takes place.
6. Operations and Maintenance – This step is where the system becomes operational and that the sponsors needs are met with expected system performance. Hardware and software is maintained and upgraded as necessary to continue expected operation and performance. User training is maintained for users and support for reported problems is ongoing.
7. Disposition – This is the end of a systems life cycle and shutdown is scheduled due to it becoming obsolete. Data is preserved for possible reactivation or future access. The emphasis is on ensuring that the system components along with the data is prepared and disposed of accordingly (Brownfield, n.d.).
Describe the specific tasks that should be taken at each step in the database development for your selected database:
* Requirement Analysis – Determine the information needs of my organization so that I can develop a database. What do my employees need in the way of accessing, storing and writing information? Show activity steps in each department.
* Logical Design – Create a conceptual model (an entity-relationship diagram) based on findings in the requirements analysis that shows tables, fields, and primary keys of the database and show table relationships (keys). Tables must then be normalized to resolve problems and maximize efficiency.
* Physical Design – Find ways to maximize database efficiency. Pay attention to the two slowest operations in an RDBMS – retrieving and writing data.
* Implementation – Install the system. I expect this will include all hardware, software and labor in actual installation and then training the employees on system use.
* Monitoring, Modification, and Maintenance -- Maintain the systems hardware and software with updates, upgrades. Train employees on new features and upgrades. Monitor for problems with the system (Brownfield, n.d.).

A description of the 3 steps in database...

Other Papers Like Cs251 Fundamantals Of Database Systems Ip 1 - 5

Exhibition Report Benoit Aquin, Untitled – from the Series “L’odyssée”, 1997, Print 2003, Ink-Jet Print, 1/5, Montréal Museum of Fine Arts

786 words - 4 pages life. Instead, Benoit Aquin shows the hidden side of a city, what citizens cannot see if they do not wander into the night. We can observe in Benoit Aquin, Untitled – From the series “L’Odyssée”, 1997, print 2003, Ink-jet print, 1/5, Montréal Museum of Fine Arts, a man walking in the streets of Montreal at night, dressed up as a white angel, with a pair of wings and a wig. His face is covered with makeup, making us think of the Joker in

"Biomes Of The Earth" Explains Biomes, Includes A Detailed Paragraph About Each Of The 7 Biomes Of The Earth.5 1/3 Pages Long

1055 words - 5 pages A Biome is all of the life zones, all plants, animals, and other organisms, as well as the physical environment in a particular area. A biome is characterized by its plant life, which is determined by its location. For example, northern coniferous forests exist in sub-arctic portions of North America and Asia, but further north, the conditions are simply too harsh and the season too brief for trees to grow. Instead of trees, the short vegetation

intro to networking

1382 words - 6 pages running on some computer that acts in the DNS server role, per the DNS protocol, which means that the server keeps a list of names and corresponding IP addresses, ready to reply with that information to a DNS Request from any DNS client. DNS client- Any computer whose software includes the DNS client function, which includes most computer operating systems today, with which the client can take the text name identified by the user and send a

Network Addressing

1091 words - 5 pages - and - The available IP addresses for both networks were then divided between the type of device, and further divided by the type of room. 2. Staff-accessed computers will be designated to network 1, which is the network. Starting with the first floor, the network addresses will be as follows: * The demarcation point will connect to the firewall, which will be assigned IP

Nt1210 Lab 8 Review

1165 words - 5 pages 1. Which of the following answers describes the TCP/IP network layer? D 2. Which of the following answers are IP routing protocols that dynamically learn IP routes on behalf of IP routers? (choose 2) B & D 3. Which of the follow answers list a function related to TCP/IP network layer tasks, but the task is not defined as part of IP? (choose 2) B & C 4. Host 1, with IP address, sends an IP packet to Host 2, whose

Netw 209 Lab 551

819 words - 4 pages R2 configs hostname R2 no ip domain-lookup enable secret class banner motd "message of today" int fa0/1 ip address no shutdown int s0/0/0 ip address no shutdown int s0/0/1 ip address clock rate 64000 no shutdown int Lo0 ip address 209.165.200. 225 router ospf 1 network area 0 network area 0

Router Ospf

2260 words - 10 pages R1> R1>en Password: R1#show run Building configuration... Current configuration : 963 bytes ! version 12.3 no service timestamps log datetime msec no service timestamps debug datetime msec no service password-encryption ! hostname R1 ! ! ! enable secret 5 $1$XA/N$cs9QtuPIK5Y/RcThoNug2. ! ! ! ! ! ! ip cef no ipv6 cef R1#show run Building configuration... Current configuration : 963 bytes ! version 12.3

Business Review

5388 words - 22 pages – Wireline Trouble Tickets Metasolve – Wireline IP Management Netcracker – Wireline Network Configuration NGN – Next Generation Network NMC – Network Management Centre NOC – Network Operations Centre SAM –ALU Network Manager SMA – Wireline Network Element tracking SRT2 – Ordering Tool for Enhanced Services (Systems Request Template) 81 Wireless IP Solutions – Overview Access at the Point of Need Infrastructure – extends business applications

Netw204: Assignment 4, Link-State Routing and Ospf

539 words - 3 pages becomes the designated router if the current designated router fails. The BDR is the OSPF router with the second-highest priority at the time of the last DR election. | 4 | Database Description packets (DBD) | Contains an abbreviated list of the sendingrouter’s link-state database and is used by receiving routers to check against the local link-state database | 5 | Designated Router (DR) | The designated router enables a reduction in the number of

Chapter 3 Assignment 1

1318 words - 6 pages Annette Durie NT1210 Unit 3 Assignment 1 Key Terms: TCP/IP Network – A computer network that uses the standards defined and referenced by the TCP/IP model. Networking Standard – A document that details information aabout some technology or protocol related to networking, and that document has been passed through a review and approval process that certifies the document as a standard. TCP/IP model – An open collection of standards related

Netw204: Assignment 4,

542 words - 3 pages the designated router if the current designated router fails. The BDR is the OSPF router with the second-highest priority at the time of the last DR election. | 4 | Database Description (DBD) | Contains an abbreviated list of the sendingrouter’s link-state database and is used by receiving routers to check against the local link-state database | 5 | Designated Router (DR) | OSPF router that generates LSAs for a multi-access network and has

Related Essays

: Ab #1 Fundamentals Of Information Systems Security

661 words - 3 pages complete the form online and save it using Adobe Reader. You may experience problems with either or both of these actions if you are using any other software program. Lab Assessment Questions & Answers 1. Name at least five applications and tools pre-loaded on the TargetWindows01 server desktop, and identify whether that application starts as a service on the system or must be run manually. windows applicaTion loaded 1. 2. 3. 4. 5

The Way Shakespeare Contrasts Love And Hate In Act 1 Scene 5 Of Romeo And Juliet

2781 words - 12 pages The Way Shakespeare Contrasts Love and Hate in Act 1 Scene 5 of Romeo and Juliet In the 16th Century, William Shakespeare wrote a play that captures the imagination and emotions of people all around the world. The play's title is the famous, Romeo and Juliet. Arthur Brooke originally wrote another similar poem. It was a narrative poem published in 1562, called ' The Tragicall History of Romeus and Juliet.' William

Exploring The Ways That Shakespeare Makes Act 1 Scene 5 Of Romeo And Juliet Dramatically Effective

2895 words - 12 pages Exploring the Ways that Shakespeare Makes Act 1 Scene 5 of Romeo and Juliet Dramatically Effective Romeo and Juliet is a tragic love story, where Romeo and Juliet fall in love but soon find out that their love is forbidden as they are from separate houses, the Montague and Capulet houses. They have to hide their love from their parent, problem a rise which causes death for both of the lovers and friends. There are many

How Did The Interdependency Of The Alliance Systems Help Lead To The Outbreak Of World War 1? Was It Only The Alliance Systems Which Led To War Or Are There Other Factors To Consider?

1158 words - 5 pages interdependency of the alliance system did play a major role in the lead up to World War 1 but it was not the only major reason.As we can see, the alliance systems had the opposite effect. Also, imperialistic countries such as Germany who had a superior attitude which made them believe that they had the right to gain more territory in Europe with the help of their allies and they thought that if Austria-Hungary invaded Serbia, it would give them