this is y cis336 week 2 lab, I need help with answering the question

February 22, 2020/in Feeds /by Munene david

this is y cis336 week 2 lab, I need help with answering the question

CIS336 Lab 2: The Expanded Entity RelationshipDiagramLAB OVERVIEWScenario and SummaryThis lab introduces the next step in crea±ng a data model, the En±ty Rela±onship Diagram (ERD). You willbe given a business scenario for a University Medical Center, which is a small community hospital. Thebusiness speciFca±ons will outline a number of things about the business, some of which will applydirectly to the database you are being asked to model. There is a table that lists the en±±es (tables) thatwill be needed for the database and related a²ributes (columns) for each en±ty. There is also a columnthat lists speciFc informa±on about the en±ty that will be helpful in determining its rela±onship to otheren±±es within the model.Be sure to include the minimum and maximum occurrences of each rela±onship (cardinality) and tosupply a name to the rela±onship that will work in both direc±ons. Make sure to use Crow’s ³eetnota±on in your ERD.Narratve/Case STudyThe University Medical Center is a small, community hospital. A new hospital administrator has recentlybeen hired by the Board of Directors, and directed to right-size pa±ent care and pharmacy services andimprove proFtability. The hospital operates three clinical facili±es: the main hospital, a mid-town clinic,and an Urgent Care loca±on. The hospital also o´ers selected in-home care services. Many of thepa±ents are repeat or regular pa±ents who receive regular treatment for various condi±ons, and manyu±lize the hospital’s pharmacy services for prescrip±on medica±ons.The pharmacy dispenses about 3,000 di´erent prescrip±on medica±ons of various kinds. Everyprescrip±on is associated with one pa±ent, and is logged by the dispensing clinic. The new administratorwants to know which drugs are most prescribed, and also which are the most proFtable.The following is some general informa±on about the organiza±on and its current processes.The hospital operates three clinical facili±es.A healthcare worker logs in at a facility at the start of a shiµ and logs out at the end.The name, address, Social Security number and other informa±on is recorded for everyhealthcare worker.All healthcare workers have one billing rate, which is determined by their job descrip±on.Each medica±on dispensed by prescrip±on is linked to both the prescrip±on number and themedica±on ID number, recording the item price and the quan±ty dispensed.As a convenient and a´ordable means of providing hospice care, pallia±ve care, and convalescent care topa±ents that need occasional/intermi²ent skilled nursing, but do not require hospitaliza±on, the

View

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

To apply the second normal form, you move columns that don’t depend on the entire primary key to another table

February 22, 2020/in Feeds /by Munene david

To apply the second normal form, you move columns that don’t depend on the entire primary key to another table

and establish a relationship between the two tables. This ______________?

A.) reduces redundancy but makes maintenance more difficult
B.) reduces redundancy and makes maintenance easier
C.) increases redundancy but makes maintenance easier
D.) increases redundancy but makes the data more consistent

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

This is my week3 lab, could you please help me with it?

February 22, 2020/in Feeds /by Munene david

This is my week3 lab, could you please help me with it?

ATTACHMENT PREVIEW Download attachment

CIS-336: Lab 3: Building the Physical ModelLAB OVERVIEWScenario and SummaryThe lab for this week addresses taking a logical database design (data model) and transforming it into aphysical model (tables, constraints, and rela±onships). As part of the lab, you will need to download thezip Fle ±tled CIS336Lab3²iles from Doc Sharing. This zip Fle contains the ERD, Data Dic±onary, and testdata for the tables you create as you complete this exercise.Your job will be to use the ERD Diagram found below as a guide to deFne the table structures andconstraints using both CREATE TABLE and ALTER TABLE statements. Once this has been done, you willneed to write the INSERT INTO TABLE statements to insert the data provided into the table. The datashould verify that the constraints you have created are valid and deFne the correct referen±al and dataintegrity constraints asked for. Lastly, you will write SELECT statements to query the tables and verify thedata was populated.Please use exactly the data provided, without addi±on, dele±on, or altera±onexcept as directed, as your results may be evaluated against expected results generated using this exactdata set.Narratve/Case STudy²or this lab, you will be crea±ng SQL statements to build a series of rela±onal tables, using SQL CREATEstatements in a script Fle format for the Student Database. You will then populate those tables throughthe use of INSERT statements with sample data.You will need to create a script Fle and name it YourName_Lab3.txt containing the following code.1.The drop table statements listed later in the speciFca±ons of this lab.2.The CREATE TABLE statements required to build the sixtables.3.The INSERT statements necessary to insert all of the sample data.4.Six select statements to verify that the data is in the tables and accessible.To help you accomplish this task successfully, you are being supplied with the ERD Diagram whichfollows, and the exact data to be inserted into each table, which may be found via the Doc Sharing tabon the course website.The following guidelines are being provided to help assist you in crea±ng your script Fle.Use the names for the tables and columns as listed in the ERD. Do not change them as it willa³ect your grade.Crea±ng ConstraintsoCreate all NOT NULL constraints as indicated in the ERD.oCreate all PK constraints as indicated in the ERD.

View

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

Present a detailed data model for your project scenario. You can create your data model using Microsoft Visio 2010,

February 22, 2020/in Feeds /by Munene david

Present a detailed data model for your project scenario. You can create your data model using Microsoft Visio

2010, which you will have access to through iLab and Microsoft Excel, which comes with Microsoft Office. Other tools may be used as long as the output is legible and conforms to standard format. (i.e., I will not be able to grade the data model if I cannot tell what it is supposed to be!). Your data model should include a minimum of an ERD and metadata chart (data dictionary).

Deliverables for This Task

Task 0 proposal (with any revisions or updates)
A completed Data Model to include the following.
- An ERD, showing all tables, related attributes, and the primary and foreign keys. This diagram must show both the relationship and cardinality of the relationship using accepted notation. The ERD should be formatted to allow printing on a single 8×10 page. It should be submitted as a Word file (copy and paste from Visio).
- A Data Dictionary (or meta data chart) showing a minimum of the table name, columns, data types, length, and constraints. It should be submitted as an Excel file. Follow the format of the Data Dictionary supplied for Lab 3.

As attachment I’m sending the task 0

ATTACHMENT PREVIEW Download attachment

THE FARMERS PRICE CENTERThe farmer’s price center is about helping farmers acquire farm inputs easilyand conveniently.Through relevant branches and supportive staff, the farmersprice center provides a fresh perspective on the day to day hardships that farmersface. The farmer’s price center is run by a practicing farmer with first handinformation as he holds a bachelors degree in agriculture. His unique perspectiveallows farmers to automatically connect with his point of view. The farmer’s centeris equally informal as it is also a mentor or a friend. Besides selling farm inputs,the center guides farmers overcome their challenges. The farmer’s price centeraddresses the farming and farming management sector. The people who purchasefrom farmers price center are either practicing farmers or want to start a venture inagriculture. They have a natural drive to create agricultural products and seek outprofessional advice. The ideal customer for the farmer’s price center would be thenew farmer or investor who wants to start an agricultural venture or manage theirfirm better.The farmer’s price center provides a comprehensive resource thatanswers the questions farmers have while at the same time giving them a step bystep way to succeed.Mostly, farmers do not have good mentors or resources toaccurately give practical and working answers to their pressing questions.

View