SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 26 Mar 2018 My Price 10.00

develop the requirements upon which the system

I need some help with my assigment.

 

 

The main thing I need help is with the tables. Not too sure what to put in it.

 


Project 1  Each of you has had a topic assigned for this project based on your submission for assignment 2.  You can locate your topic in the grading comments for assignment 2.  In the next few assignments you will build, populate and query your database.  Please do NOT work ahead.  I will grade each assignment and make suggestions for corrections before you begin the next assignment.  If you work ahead, you might have to delete your work and start over.  I will try to grade them as quickly as I can.  The sooner you turn in the assignment, the sooner you can start on the next part.  If everyone turns in the assignment at the last minute, you will have a very limited time to do the next part.  Keep this in mind when scheduling your time for this course. For the first part of the project, you are going to do two important tasks.  First, you have to develop the requirements upon which the system will be based.  In order to do this, you will create three uses (separate users or separate uses if yours is not a corporate type database) for your database.  For each use/user create requirements that must be met.  These requirements are not just a list but a detailed explanation of each requirement and why it is important.  Requirements may be data needed for the user to do his/her job or formatting or domain requirements that must be enforced. This is not a list of what queries the user might want answered.   Frequently the requirements for different user groups conflict.  Make sure you specify any constraints that must be implemented to meet the different user’s requirements. Once you have created the three sets of requirements and constraints, combine them into one set of requirements.  Make sure you note what compromises you had to make to come up with a single set of requirements. Finally, create three or more relations needed to implement your requirements.  For each relation create a table using the following format.  Do not create a different format because it is like the one you use at work or you think it is better.  A consistent format in everyone’s project speeds the grading process.  Please remember to list the primary key(s), foreign key(s), and indices below the table.  If there is not one, type the label and leave the information blank.  A foreign key must list the table it references and if the attribute names are different in the two tables then it needs to list the attribute as well.  For example, facultyID references FID in FACULTY.  facultyID is the attribute name in the relation you are describing and FID is the attribute name and a primary key in the relation FACULTY that you are linking to.  Do not index your primary key.  Only index attributes that might be used frequently in queries but are not primary keys in the relation.           RELATION NAME Attribute Name Data Type Size Constraints/Domains Cascading Problems              Primary Key(s): Foreign Key(s): Indices:  2   

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 26 Mar 2018 01:03 PM My Price 10.00

  ----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------  ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------

Not Rated(0)