Category: Databases

Items to create: Tables, columns, checks, defaults.
Deliveries:
Dictionary
Database Diagram
Screen Captures of navigation panel expanded to show Bed column checks and defaults, and Age column (example provided here.
MDF and LDF files
1. Build must match dictionary, and tables must match ERD and RS design.
2. Bed table must have a checks and defaults as stated in narrative.
3. Tables must be connected with proper PKs and FKs.
7. Tables based on associate entities must have proper CPK notation for Key and Index, or use surrogate key.
8. PK of each table must be set to data type INT and Identity seed 1, increment 1.
9. Patient age must be calculated column. Hint for calculation: datediff(year,dob,getdate()).
10. Charges should be money data type, because it is already formatted for 2 decimal places.
11. Hours should be decimal (4,2) data type, so that someone can work fractions of an hour. The 4 indicates total places, the 2 indicates number of places to the right of the decimal. This is also true for the numeric data type.
Contact me tru whatsApp +18134860150

We want to design a database for a “Smart Urban Farming” system. This would collect data from various sensors like soil moisture, temperature, and sunlight, and integrate it with information on plant growth stages, water usage, and fertilizer requirements.
The database could also manage inventory for seeds, tools, and harvests. Users could analyze the data to optimize farming practices, ultimately making urban farming more efficient and sustainable. Consider the following requirements:
The “Smart Urban Farming system” start the monitoring by distribute a different set of sensors in the field where each senor has an id and a location.
Each senor will sense and collect a data depends on its functional categories (Soil sensor, temperature sensor, light sensor, pH sensor).
Each sensor equipped with a sleep mode (Active/ Unactive) property to allow an energy aware scheduling.
The collected data is maintained by the following properties: data id, sensor id, timestamp date, and the sense value.
In the field there are many plants, each is identified by id, a plant name, ideal moisture, ideal temperature, ideal light.
Also, we want to maintain the plants growth stage (Seed, Sprout, Vegetative, Flowering, Fruiting).
All tools, seeds and other resources should be stored in inventory where each inventory quantified by the inventory id, inventory name, quantity, last restocked date.
Each user identified by a user id, a user name, a password, and a role (Supervisor, Farmer).
i want to design EER and ER model (diagrams) and Description of ER Data Model component .

Optimize the following SQL Query by using Query Tree and Heuristic Rules:
SELECT C.Fname, E.Fname
FROM Employee AS E, Customer AS C, Order AS O
WHERE E.EMP_ID=O.E_ID AND C.City=’Jeddah’ AND C.Customer_ID=O.C_ID AND E.EMP_ID=’12943’
You should show the Initial Query Tree and add a screenshot of the Query Tree after applying each rule. [0.5 for each correct step]

Prompt: GIS systems have been very expensive and cumbersome to use. After reviewing a YouTube video or utilizing google.com, what is your opinion on how the feature within Microsoft Excel for maps at the world, state, and zip code level can be used in your workplace?

1- A zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation).
2- You are advised to make your work clear and well-presented.
3- You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
4- The work should be your own, copying from students or other resources will result in ZERO mark.
5- ·Use Times New Roman font for all your answers

Using Oracle SQL developer
Data Warehouse/Design and Implementation.
Phase 1: Design and Implement data marts.
Step 1: Using your database, develop the star schema diagram, test it (report and chart) using Excel pivot, and test again using MSSQL pivot.
1. Zeota-Others: Employee/user access Analysis Report

follow the instructions on the cover page. this is an assignment to our class IT-403: Fundamentals of Databases

Consider the below ER diagram for a music database. Write SQL statements to create the
corresponding relations and capture as many of the constraints as possible. If you cannot capture
some constraints, explain why.

please use your own words don’t copy and paste (no plagiarism)
‏- Please use keyboard (don’t use handwriting)
‏- All answered must be typed using Times New Roman (size 12, double-spaced)
‏- I want answer with APA reference for per question
##The assignment should not contain sexual orientation or the like

1.The paper should create a list of requirements for a Smart Highway with at least five (5) integrated Smart systems identified in your research with at least 40 requirements (total) for these five (5) Smart systems.
2. detailing your proposed trip on a
Smart Highway. The paper must include all five (5) of the integrated Smart systems identified in your
research and two (2) requirements for each of the five (5) integrated Smart systems.