Question
For today's date would it be considered as an int, or a varchar? Am I labeling my items correctly? (varchar, int, and so on) Am
For today's date would it be considered as an int, or a varchar? Am I labeling my items correctly? (varchar, int, and so on) Am I on the right track for this assignment?
For my assignment I am suppose to create a database structure that holds information for a doctors office. The doctor wants to store demographic information about patients (address, age, gender, marital status), medications dispensed (when, what, quantity), and billing information (amount billed, amount and date paid, insurance information). You do not have to create the database. Sketch out the structure as follows: There should be three tables and each record should have at least four fields. You must include the information given in this problem but you can add other information you feel is significant.
Here is what I have so far:
Dalice Hudson 2-8-21 Lab 4 Doctor's Office I have sketched out 4 different tables. 1) Patient includes firstName, lastName, customerld, and treatment Plan. 2) Demographic Information includes patients address, age, gender, and maritalStatus. 3) Medications Dispensed includes patients startDate, endDate, productName, and productQuanity. 4) Billing Information includes patients amountBilled, amountPaid, datePaid, and insurancelnfo. Patient Medications Dispensed firstName varchar(15) startDate int lastName varchar(15) endDate int gender varchar(10) productName varchar(25) treatment Plan varchar(50) productQuanity int Demographic Information About Patients address varchar(50) Billing Information amountBilled int age int amountPaid int customerlD int dateDaid int maritalStatus varchar(10) insuranceInfo varchar(75)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started